Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference to a different Sub
pontiy, You can't reference another sub, but you can keep the data from
that sub by declaring a Public variable. See example below. This way the data is availble for any sub you wish to use it in. enjoy, Rick PS: Declare the public variable at top of UserForm Code, or in Code Module... Option Explicit Public Ans as Variant Private Sub CommandButton1_Click() Ans = InPutBox(prompt:="What is your answer?") ..... End Sub Private Sub CommandButton5_Click() Range("A1").value = Ans End sub "pontiy" wrote in message ... I'd appreciate you answering this question for me. I have prompted the user for an input in one of my subs: Private Sub CommandButton1_Click() And now I need to use this data in a different sub: Private Sub CommandButton5_Click() How do I reference to a different sub to get my value? Thank you. -- pontiy ------------------------------------------------------------------------ pontiy's Profile: http://www.excelforum.com/member.php...o&userid=32885 View this thread: http://www.excelforum.com/showthread...hreadid=528325 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |