Enter data to run command button

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,


How can I prevent a command button from running before data is entered into a cell? I have a workbook that refreshes data based on when a customer number is entered into a cell. If the command button gets clicked before the number is entered, it doesn't work and the workbook has to be closed out and reopened for the button to work again. Any thoughts on how I can fix this? Thank you

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
on click of the button, check if the data is populated. if not then exit out sub
0