Need help creating a userform with optionbuttons

  • Thread starter Thread starter TB
  • Start date Start date
T

TB

I'm looking for help creating a userform with optionbuttons. I can generally
find my way around simple macros, but I've never tried programming a
userform before, and finding help on the subject seems to be almost as tough
as finding the holy grail. Any help, pointers, links, examples... anything
that would help with the following pseudocode would be appreciated.

If a value is entered into any cell in range("F10:F16") then
Call the userform
Userform would consist of:
Choice 1: Append text in range("B25"), and manipulate data
..
..
..
Choice 8: Append text in range("B25"), and manipulate data
Click OK button to do the above
Click Cancel button to clear userform and do nothing.

Right now, this is new territory for me, but I have to take the next step.
Problem is, I can't find the stairway! As I said, any help will be
appreciated. Thanks.
 
Hi TB

This is a combination of small, common tricks, where creating the form is the hardest to
walk you through in a posting. Email me with a valid return address, and I'll make you a
sample workbook.

Best wishes Harald
Excel MVP
 
Back
Top