View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_19_] John[_19_] is offline
external usenet poster
 
Posts: 87
Default Create list of macros

I'm toying with the userform route. Looks pro,issing but it seems really
hard designing decent looking textboxes in excel. I can get done what I
want to do but it looks terrible.

John

CurlyDave wrote:
On Feb 17, 4:34 pm, John wrote:
I would like to present user with a list of macros with explanations of
what they do. Have one button that is "Macros" and that opens a macro
(or something) that lists the macros. Then can select one to run.

Thanks

John


Alt&F8 ?
This shows all the macros in the WorkBook, if you have made
explanations for each macro they will show there.

Another other way would be to create a userform with command buttons,
and each button would have your separate VBA code, you could have an
explanation of what each button does beside the command button.