View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default User Forms - Command Button defines value to be used later

I have a very basic User Form and I can get it to display. This is the
limited code I have within the user form:

Private Sub cmdMonthly_Click()
Dim Inchstone As String
Inchstone = "Monthly"
Unload Me
End Sub

Private Sub cmdWeekly_Click()
Dim Inchstone As String
Inchstone = "Weekly"
Unload Me
End Sub

I've tried to find info on User Forms but haven't found anything related to
this. How do I get the value of Inchstone back into the main code from
which I call the user form? Again, if I've done something wrong, please let
me know.

Thanks in advance,
Barb Reinhardt