Narayan - I'm speechless! Thank YOU so much for taking the time to do that - I didn't expect the work done for me but it is much appreciated.
I'll have a play & let you know if I have any questions.
Andrew
Hi all,
I'm building a calculator for retailers to use in Excel that will handle four variables:
- sell price $
- cost price $
- margin %
- gross margin $
The brief requires that when ANY two of the variables are entered, the remaining two will calculate.
QUESTION: Currently...
Hi all,
I need some help with a project I'm currently working on please.
In the PIVOT tab in the following spreadsheet I have formulas in columns L to O that refer to values in the Pivot Table.
I would like to do this properly by creating calculated fields/items to truly make use of Pivot...
Public Sub Combobox_Reset()
user_input = MsgBox("Are you sure you wish to RESET the sheet ? (Y/N) : ", vbYesNo)
If user_input = vbYes Then
'
Set List_of_objects = Me.OLEObjects
For Each control_object In List_of_objects
If control_object.Name Like "ComboBox" & "*" Then...
Narayan,
Back from holidays and have a loose end if you could help please?
In the Yes/No box above I need a line of code to handle the action if a user selects 'No' ie close the box & do nothing.
Could you assist please?
Many thanks
Andrew
Thanks Narayan,
Back from a business trip & continuing this!
hmmm I get 'Compile error: Invalid use of Me keyword'...any ideas?
With regards to functionality, I have a button (just a shape linked to a macro) on the chart 'Reset Chart', when this is clicked I'd like an 'ok/cancel' box to...
Thanks Narayan, hmmm I'm going to stop pursuing sequence chart Nirvana and just leave the comboboxes showing - Pareto's rule!
My last task is the reset functionality - I just tried using the macro recorder to record selecting a combobox & clearing the contents but it didn't register.
What...
At present my VB code for the comboboxes is below, what do I need to add to enable the 'Always' to 'Focus' and change the 'ForeColor' to match the 'BackColor'?
There are approximately 100 comboboxes on the worksheet so my preference is to make them as unobtrusive as possible, but I understand...
Some context: I'm building a linear sequence chart (modified Gantt chart) which visualises the process plan for a longwall mining operation in Central Queensland in Australia. This isn't a chart in Excel terms but rather a conditionally formatted worksheet with tasks down the Y-axis and distance...
Thanks Narayan,
How would you expand that code to say if value is not equal to 100 then combobox visible? When I include your code I get an error when selecting any value other than 100%.
Also when you used '100' will Excel interpret that as '100%'? or should we use '1'?
I also thought of passing it through a helper cell as a solution, but was waiting to see what you came up with! :)
I think we've finally nailed it! Rather than using the LinkedCell field in Properties, I added a line of code & it works like a charm.
Many thanks for your efforts Narayan -...
The Combobox is showing 06:00, the linked cell is showing 0.25.
If you refer to the code at the start of this post you can see how we tried to tackle this problem.
When the value passes from the named range, through the combobox & into the linked cell it looses its hh:mm formating.
Hi all,
I have a Combobox with percent complete in the menu (ie 0%, 20%...100%).
When the user selects 100% complete I would like to hide the Combobox.
Any ideas on how to do this?
Many thanks
AP
Ps Excel 2007 & a basic understanding of VB!
Many thanks Narayan,
That all works beautifully, however I've run into the same problem that led to the development of the original code.
The Linked Cell is showing the value not in hh:mm format, but as a number so 06:00 appears as 0.25 ie one quarter of a day. I have changed the format on...
Hi all,
I've pretty limited skills when it comes to VB, so enlisted the aid of a colleague when I wanted values in the drop down list to be shown as hh:mm format. FYI a named range is feeding the drop down list & there were issues getting it to appear as hh:mm.
Below is what he came up with...