Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I'm having trouble getting my Module procedures recognising the values from a Userform A simple example is where I have a Userform with a textbox ("txtTest") and a command button ("cmdRun"). The code for cmdRun is as follows ---------------------------------- Private Sub cmdRun_Click( Call MyMacr End Su ---------------------------------- The MyMacro procedure resides in a standard code module, as follows ---------------------------------- Sub MyMacro( Dim strTest as Strin strTest=txtTest.Valu End Su ---------------------------------- However, when I run this, I get an error "Object Required", i.e. the MyMacro is not recognising the textbox on the userform Could someone please help Thanks heaps SuperJas. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to pass values from a userform to a standard module? | Excel Programming | |||
Passing variables from module to userform | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Userform with template class module problem | Excel Programming | |||
Delete userform/module using VB | Excel Programming |