Thread: Show Results in TextBoxes, ONLY if All TextBoxes have Data in them
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
  
Posts: 586
Default Show Results in TextBoxes, ONLY if All TextBoxes have Data in them
I have a total of 8 Textboxes and 1 ComboBox in a UserForm. Textboxes 1-4
show calculation results that are dependent on Textboxes 5-8 and the
ComboBox. I am currently using the Change Event in Textboxes 5-8 and the
ComboBox for an instant calculation for the user to see. My question is how
do I get Textboxes 1-4 to be blank if any of the Textboxes 5-8 or the
Combobox is blank.
Reply With QuoteReply With Quote