Thread: macro-vba
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
K11ngy K11ngy is offline
external usenet poster
 
Posts: 31
Default macro-vba

I have a data entry form for loading details to Invoice (sheet 1) and this
data entry form loads as soon as file opens. It opens with the text boxes
still with old data in, is there a way of either the boxes being empty when
form loads or actually clearing after user enters OK?

I would also like to add a control that prints the Invoice after data input,
in my instance "Sheet 1" Cant seem to work out the coding

regards

Steve