1) Make the Buttons on the Userform
2) Double Click the Button .. (should Take you to the Click event
code)
3) in onClick Event for each Button ..

Cells(row,Column).Value=90028.1
or

Cells(row,Column).Value=90028.2


Hope that Helps
Andrew ;-)

"Brad E." wrote in message
...
|I have never programmed for a userform before, so I may need precise
help here.
| On a worksheet tab called 'Tables', I have a list of ZIP Codes with
City and
| County. The single column of ZIP Codes is a named range (ZIPS).
| Some of the ZIP Codes are in the table two times, for instance,
| 90028.1 / Hollywood N of Sunset / Los Angeles (County)
| 90028.2 / Hollywood S of Sunset / Los Angeles
| 90038.1 / Hollywood N of Santa Monica / Los Angeles
| 90038.2 / Hollywood S of Santa Monica / Los Angeles
| What I am looking for is when a user enters the ZIP Code of 90028, I
would
| like the userform to come up with 2 buttons on it with the 'City'
| description. After selecting one of the buttons, I would like the
| user-entered 90028 to change to 90028.1 or .2.
|
| Row 86 = user-entered ZIP Code - I have Data Validation to only
allow ZIPs
| which are allowed, and because of this, I have also entered 90028
and 90038
| into the ZIP Code list. For City and County, I have entered "*".
| Row 87 = VLOOKUP City; 88 = County
| I already have a Worksheet_Change event, with a Select Target.Row
| Case 86
| If Target.Offset(1,0).Value = "*" then
| 'I am not positive how to call the userform.
| End If
| I also have the 'SplitZIP' userform created, but I need help
changing the
| Caption depending on which ZIP Code is selected. Lastly, if the
cmdSplit1
| (cmdSplit2) button is selected on 'SplitZIP', I need to add 0.1
(0.2) to the
| user-entered ZIP Code.
| --
| Sorry it's so long and TIA, Brad E.