assigning a value to a variable

[Phillip2]

I have a worksheet with 100 buttons. Each button represents a Customer’s record number. I’m working on a macro to assign to each button that when clicked would do the following:

• Open the userform CCX_Form
• Assign the customer’s record number to the variable TBrecord
• Run the subroutine Private Sub Search_Click()

My form opens, but I’m getting an error 424 (Object Required) when using the following code. What am I missing?

Sub Rectangle1_Click()
CCX_Form.Show
TBrecord.Value = "001"
Call Sub Search
End Sub

Thank you in advance for your time and help.

 

[Phillip2]

Thanks Fluff, I really appreciate your help. I was afraid of that. I'll just take it out and press a search button when the form opens.

 

[Fluff]

If you put Search_click into the initialize event (as per your image in post#11) then you don't need to click the button

 

[Phillip2]

Ok _ I'll try it Thanks