View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
clhamilton clhamilton is offline
external usenet poster
 
Posts: 1
Default How do I call VBA subs from different spreadsheet from code behind form?

Inherited existing application, VBA validation subs are trigger from
Worksheet_Change and/or Workbook_SheetSelectionChange. Change subs call
subs from separate worksheet which error when called from Code Behide Form.

Form added to allow user input into multiple spreadsheets.

How do I call VBA subs from different spreadsheet from code behind form?

clhamilton