| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference a variable declared in VBA
I have a question and dont have the slightest idea on how to go about it.
I have a cell G8 that will get text input to it. If G8 has text in it, then cell B8 will input the persons name retrieved from VB with a public variable name of "name." I was thinking the best way to do this is with a formula in cell B8 that is something like: =IF(Range("G7").Value<"",Module1.Name,"") Module1.Name is the Module and Public Variable in that module that i want to reference. any help would be great, not too familliar with formulas. thanks again! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable reference in countif | Excel Worksheet Functions | |||
| variable as a cell reference? | Excel Worksheet Functions | |||
| How to use variable in reference | Excel Worksheet Functions | |||
| Macro for autofilter using variables declared in worksheet | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Threaded Mode
