View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] shumwaymeister@gmail.com is offline
external usenet poster
 
Posts: 14
Default Customizing userforms on button clicks

I have a series of buttons all using the same Userform. However, I
would like to be able to personalize the title of the userform -
depending on what button is clicked.

The long way to do it, would be to have a short macro for each button,
that would each generate the userform and accordingly change the
caption details.

But I am assuming there should be a shorter way, to enable a large set
of buttons to use the same userform and be able to personalize the
title as required. Perhaps a series of case statements or even somthing
simpler??