How do I make Macro Buttons Transparent ?

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Hi all,

I am creating an interactive model with option buttons,
which are linked to macros. I need these buttons to change
descriptions according to previous selections.

Is there a way of getting a Macro Button to lookup from an
Excel cell or a way of making the button transparent so
that the cell description is visible ?

Thanks,

Kevin
 
Kevin

Form controls can have their names changed within a macro........

CommandButton1.Caption = "New Name"

if your various functions are assigned to different controls, you migth try
nesting the controls on top of each other, then use the visible method to
turn them on and off eg

CommandButton1.Visible = True
Coomand Button2.Visible = False

With the two controls physically located on top of each other,
CommandButton1 shows whilst CommandButton2 is invisible, reversing this
logic changes them. The more you add the more tricky the logic, but the
principle is the same. This way event buttons event can be dealt with
separately.

HTH
Cheers
Nigel
 
Back
Top