View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KIM W KIM W is offline
external usenet poster
 
Posts: 52
Default Simply show UserForm

How can I most simply have user display a userform with the following
requirements:
1. I don't want them to have to learn and remember keyboard shortcut
2. Clicking on worksheet is desirable solution
3. User may rearrange and add columns
4. User may change width of columns
5. Userform is relevant to only SOME columns, so if it were a button it
would only be on 10% of the columns in a many column worksheet (not designed
to print)
6. Same userForm is launced regardless of column one is working in.
7. BTW, this UserForm ends up writing text into the active cell.

Thanks in advance.