Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to build a form to use for a custom public function that works
like the Insert Forms Dialog box (it appears that I can't just call and use it from VBA). What is the right control to use to allow the user to indicate the cell address. I am trying a RefEdit edit but it doesn't work the same as the control in Insert Function and I am having trouble getting the selected cell written into the formula as a cell reference. This doesn't do it. ActiveCell.FormulaR1C1 = "=BU2Gp(" & ActiveSheet.Range(RefEdit1.Value) & ")" Any advice is appreciated. Thanks, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing Cell Link on Spin Button Form Control | Excel Discussion (Misc queries) | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Variable Reference to a Form Control | Excel Programming | |||
Tool Tip Text for Form control/ Active-X control | Excel Programming | |||
How to create a form control over a specific cell | Excel Programming |