Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How public is public?
I am writing a procedure that I want to either access from the macro manager
in the excel interface (without a parameter) or call from another procedure and pass a parameter. My first inclination was - Sub ColsHide(Optional CH_Row As Integer = 1) which would set the CH_Row variable to 1 if not passed as a parameter. However this approach makes the procedure invisible to the macro manager. Next approach was to set a public variable in the calling program - Public CH_Row As Integer Sub ColsHideKen() CH_Row = 1 ColsHide End Sub but the following code in ColsHide If VarType(CH_Row) = vbNull Then CH_Row = Application.InputBox(Prompt:="Enter row number to test", Title:="COLS HIDE", Default:=1, Type:=1) Else ' CH_Row already set publicly End If works out that CH_Row exists but the following method cannot interpret it as a valid numeric input Cells(CH_Row, CH_Col + 1).Select TIA -- Ken "Using Dbase dialects since 82" "Started with Visicalc in the same year" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How public is public? | Excel Programming | |||
Public variable (or Public Const?) | Excel Programming | |||
Public variable (or Public Const?) | Excel Programming | |||
Public? | Excel Programming | |||
Public Sub Help | Excel Programming |