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




"Kevin" wrote in message
...
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




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---