Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try something like
Function Test(TBX As MSForms.TextBox) As String Test = TBX.Text End Function You can then call this with code like MsgBox Test(Me.TextBox1) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "asmenut" wrote in message ... How would one go about creating a funtion that I can use a textbox as the argument? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text Function 2nd argument | Excel Worksheet Functions | |||
How can I get around 30 argument limit of SUM function? | Excel Worksheet Functions | |||
Need Function Argument | Excel Worksheet Functions | |||
text as an argument of SUM function | Excel Worksheet Functions | |||
Pop-up function argument list | Excel Programming |