Enter data to run command button

Closed
andjan - Nov 6, 2015 at 01:18 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 6, 2015 at 01:56 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 6, 2015 at 01:56 PM
on click of the button, check if the data is populated. if not then exit out sub
0