View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Hutcins John Hutcins is offline
external usenet poster
 
Posts: 19
Default Form Control for Cell Reference

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