View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sunilpatel sunilpatel is offline
external usenet poster
 
Posts: 57
Default passing variable

i need to pass a variable (comname$) from worksheet code to an application
in a module.

i.e

Private Sub Worksheet_Activate()
comname$ = "Comboboxone"
Application.Run "test.xls'!loadcombo"
End Sub

in module 1...

Sub clearcombo()
ActiveSheet.com$.Clear 'where com$ is name of combobox
End Sub

Help will be appreciated.

Thanks