MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Change caption of button in VB from range in sheet


Posted by alfredo sanchez on April 10, 2001 7:29 PM

Hi!
Please help me with this: Is it possible to assign the CAption of a button from within VB, gettin it from value stored in a cell?. I have tried but get 'object properties calling' error. Thanks .


Posted by Dave Hawley on April 10, 2001 8:09 PM

Hi alfredo


It sure is, try this

Dim OptCaption as String
OptCaption= Sheets("Sheet1").Range("A1")
OptionButton1.Caption= OptCaption

Dave
OzGrid Business Applications

Posted by alfredo sanchez on April 10, 2001 9:21 PM

Dave: I was thinking of assigning a macro to a button from name stored in cell. Can you help with that?


Posted by alfredo sanchez on April 10, 2001 9:22 PM

Dave: I was thinking of assigning a macro to a button from name stored in cell. Can you help with that?

Posted by Dave Hawley on April 10, 2001 9:40 PM

Re: Dave: I was thinking of assigning a macro to a button from name stored in cell. Can you help with that?

alfredo, this code is for assigning a macro to a CommandButton from the "Forms" toolbar.

Dim CmdBtnMacro as String
CmdBtnMacro = Sheets("Sheet1").Range("A1")
ActiveSheet.Shapes("Button 13").OnAction = CmdBtnMacro

Dave


OzGrid Business Applications

Posted by alfredo sanchez on April 10, 2001 9:59 PM

Re: Dave: THANK YOU VERY MUCH AND IVAN TOO!!!!!