Fill text box in userform

[HansV]

"the form does not seem to open" - do you get an error message? If so, what does it say?

[adam]

No I don't get any error messages. Instead when I click the macro button. It does not open

[Rudi]

I don't think you have a name range called "StaffList"?

Either you must create a name range called "StaffList" OR
You must replace IDArray = ws.Range("StaffList") with something like IDArray = ws.Range("A10:A20").

Please note that "A10:A20" is a sample range. I don't know what you intended as the original "StaffList" range!

[adam]

Thanks Rudi. Your suggestion works fine. Im happy now

[adam]

If I want to add the lines txtBillDate, txtReceiptDate how could I added them to the code in the post=12465

[HansV]

You can add more parts like

And ctl.Name <> "txtStaffID"

before the keyword Then.

[adam]

Thank you for the help Hans.