Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass variable from module to userform and back
Howdy! I've been picking at this problem for the last couple of days,
and have searched through this group extensively. I may have actually found a solution, but if so, didn't recognize it as such. That said, I apologize in advance for beating a dead horse..... So what I'm trying to do is this: Worksheet "Index" has 22 buttons that call out 22 different modules, based on which line item of the index I want to work with. Each of these 22 modules unhides/unprotects a couple of other worksheets that I don't want visible, and then assigns a variable based on which line item it is. For example, button one assigns the cell C5 to variable R1, button 2 assigns C6 to variable R1, button 3 assigns cell C7 to R1 etc. etc. etc. After the variable is set, each of the individual modules loads up the same userform. What I can't seem to make happen is to get the userform to recognize the variable and operate on it. The reason I want to do it this way is that each command button assigns that variable for that specific cell, and then the userform will act on that variable as the base reference so I can manipulate other data on the "index" sheet in the corresponding row. How I'm setting the variable is: ___________ Static Sub C1_Modify() .. .. .. Dim R1 as Range Set R1 = ActiveCell UserForm.show .. .. End Sub ___________ Then in the userform is a text box and a couple of option buttons. What it should do is perform some operations based on R1, but it gives me a "Run Time Error '424'", Object Required. I've tried poking around with the "Property Set" statement, but don't even know if that's got anything to do with what I'm trying to do. Any assistance would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pass a variable back to the host script? | Excel Programming | |||
Pass public variable from one userform to a second... | Excel Programming | |||
How to pass a variable from Form back to calling procedure | Excel Programming | |||
How to pass values from a userform to a standard module? | Excel Programming | |||
Pass a variable from a class module | Excel Programming |