Hiding or Making Buttons unavailable

[thomas.szwed]

Hi there,

Could anyone tell me whether it is possible to make a Form Button (placed on my spreadsheet) disappear or become unavailable to use IF another cell equals a blank value?

Linking to this, can anyone tell me if you use a Forms ComboBox whether or not selecting values from its dropdowns can be further processed? i.e. if you choose option 1, then cell B3 becomes unavailable for user input (changes colour or something like that?

[dominicb]

Good morning thomas.szwed

Unfortunately, there's not much control you can have over a Forms button - you have far more options when you use a Control Toolbox button. You can hide it, show it, or even ghost it out. I think that this is the best you can do with a Forms button :

Please Login or Register  to view this content.

Which pretty much removes it. You could include a check in the first line of your code that will only run the macro if your cell value isn't blank ... ?

can anyone tell me if you use a Forms ComboBox whether or not selecting values from its dropdowns can be further processed

You cannot control the appearance of individual items in any of Excel's comboboxes. If I need to do this in any of my apps, I'll remove it from the combobox completely - again there is more scope to do this using the Control Toolbox objects.

HTH

DominicB

[thomas.szwed]

Many Thanks