View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Srikanth Ganesan[_3_] Srikanth Ganesan[_3_] is offline
external usenet poster
 
Posts: 1
Default GUI in Excel Macro

Hi,

I need to get input from the user as to what kind of file
(i.e. files with a specific file extension) he is
interested in operating the macro on. I want to have a
drop down menu with some file extension options for the
user to choose from. Once the User chooses the file
extension the macro should begin running (with the file
extension information used in the macro). The file
extension should be stored as a variable and passed on to
the main macro.

How can I implement this. Please help. Thanks

Srikanth