Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Command Button Based on Data Entry
Hello, I am completely new to VBA, so this is confounding me.
I have a form to add rows of data to a spreadsheet. I would like to change a Command Button Caption and action based on data entry. Example: user inputs width, length, and height. Command Button caption reads "Calculate Volume". When the command button is clicked, the volume is calculated and displayed on the form, the same command button caption then reads "Enter Data." When the button is clicked again, the row will be added to the spreadsheet and the form is ready to accept the next set of data. Possible? Any help appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Command Button Based on Data Entry
Far be it from me to tell you what you want, but the flow of that seems a
little bit odd. Instead of that, how about having 2 input text boxes and a lable. When the input textboxes contain valid entries, the lable displays the volume and the command button to add the lines is enabled. The command button is not enabled until the text boxes contain valid entries? That seems a bit more intuitive to me. -- HTH... Jim Thomlinson "Bill" wrote: Hello, I am completely new to VBA, so this is confounding me. I have a form to add rows of data to a spreadsheet. I would like to change a Command Button Caption and action based on data entry. Example: user inputs width, length, and height. Command Button caption reads "Calculate Volume". When the command button is clicked, the volume is calculated and displayed on the form, the same command button caption then reads "Enter Data." When the button is clicked again, the row will be added to the spreadsheet and the form is ready to accept the next set of data. Possible? Any help appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
changing the caption of a command button | Excel Programming | |||
Changing the color of a list entry based on a tolerance | Excel Worksheet Functions | |||
Changing a cell color based on date entry ... | Excel Programming | |||
Command button on data-entry form | Excel Discussion (Misc queries) |