Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello, Can I do something like this.....?
............ Dim MyTextBox as Textbox TxtBoxNum = 3 Set MyTextBox = SetTheTextBoxFunc(TxtBoxNum) ............ Public Function SetTheTextBoxFunc(num as integer) as Textbox select case num case 1 SetTheTextBoxFunc = SLNX.Textbox1 case 2 SetTheTextBoxFunc = SLNX.Textbox2 case 3 SetTheTextBoxFunc = SLNX.Textbox3 end select end function ............... SLNX is a form with a bunch of textboxes. Thanks for any help. Cant quite figure this out. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return reference from object function | Excel Programming | |||
Object doesn't support this property or method (Node Function) | Excel Programming | |||
Function for an object | Excel Worksheet Functions | |||
How to write macro to move object via if function | Excel Discussion (Misc queries) | |||
Function unable to return Collection object | Excel Programming |