Worksheet focus problem, how do I set focus?

[MichiganWilliams]

I have a userform that has users enter a supply name, re-order amount, price, and they click an option button to see if this needs to be a credit card purchase or if it can be purchased from an online database called dmlss. If the user selects credit card, its supposed to enter 1 in the 5th column, if they select DMLSS, it's supposed to enter 0. The user clicks the Add button and it's added to a separate worksheet called LookupLists.

Problem: When I run the userform from excel, it enters everything correctly except it doesn't enter anything in the 5th column. However, if I run the userform from the vba developer window (with excel open to the LookupLists worksheet), it enters all columns correctly. Also, if I try to enter 2 consecutive items, the 1st item will leave column 5 blank, but the 2nd item (once the focus has now moved to the worksheet LookupLists) it enters all 5 columns correctly. So I'm sure it's a focus issue, but I can't figure out why it's not working right. Any advice?

Please Login or Register  to view this content.

[jaslake]

Hi Michigan

I'd suggest it's not looking at the correct Worksheet...

Try this

Please Login or Register  to view this content.

or this

Please Login or Register  to view this content.

[MichiganWilliams]

THANK YOU!!!! This worked!

Please Login or Register  to view this content.

[jaslake]

You're welcome...

This would also work

Please Login or Register  to view this content.