Forum

Hans Hallebeek
@keebellah
Reputable Member
Joined: Oct 17, 2018
Topics: 8 / Replies: 365
Reply
RE: SLM Monthly Equal Revenue Calculation

How about more information like Excel version and a asample file? Guessing is not an option to obtain relevant answers

2 years ago
Reply
RE: Default item from a dropdown list, when selecting a Slicer?

I'm not sure if it works but you could generat a list in with the resulsts and link the Dropdown to this range. You have not mentioned which versio...

2 years ago
Reply
RE: Time of Day

Looks real good

2 years ago
Reply
RE: Price synchronization between 2 sheets

How your table looks like is nice to see but to help you I suggest you attach a file with the table (dummy data)

2 years ago
Reply
RE: Private Sub Worksheet_Change(ByVal Target As Range)

If it's only B9 that needs to be processed then Charle's code is perfect, but if you want to process another range you could use the worksheet change ...

2 years ago
Forum
Reply
RE: Make chart data labels an image from the spreadsheet

Just a tryout to place a logo from a link in the particular range. Place the entire url in column D as in the sample an the click the green button ...

2 years ago
Reply
RE: Make chart data labels an image from the spreadsheet

Just give me some time to place the code I am currrently using in a sample file. Will try to complete it this weekend. I honestly never took the...

2 years ago
Reply
RE: Make chart data labels an image from the spreadsheet

Yes, the name box, there you can also see which name excel generated for the new image, that's why I always use macro's. I'll try and see if I...

2 years ago
Reply
RE: Custom UI Ribbon and QAT in Personal macro book

Hmm, makes me think, I'll do some testing and update, thanks for thinking with me

2 years ago
Forum
Topic
Forum
Replies: 3
Views: 372
Reply
RE: Make chart data labels an image from the spreadsheet

Hi Robert, What you have to realize is that when you insert a picture in any sheet, range or cell, Excel gives it a new name. The first one will...

2 years ago
Reply
RE: Make chart data labels an image from the spreadsheet

Hi Robert, The value your are looking for is not the cell value but the shape's name. The routine you're using to shows the shape and gives it t...

2 years ago
Reply
RE: Cell counting by color

It's as reliable as the color you choose/pick. That's where the problem lies

2 years ago
Forum
Reply
RE: Cell counting by color

Hi Riny, I disagree, it is possible Function countRowsWithConditionalColor(data_range As Range, cell_color As Range) As Long Dim cntRes As Lon...

2 years ago
Forum
Page 9 / 25