LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 64
Default Macro to Reset data input form

I have a worksheet set up as a data entry page to allow customers to select
features in a product. This data then generates a part number to capture that
particular set of features.

However, this leaves me with the Data Input form populated with the last
customer's selections. How can I write my macro to Reset the form to the
'blank' starting position? I envision having a 'Reset' box in the worksheet
to cue the Macro.

Thanks.

Mike

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
input in number form is being multiplied by 1000 when i input. jweinograd Excel Discussion (Misc queries) 4 April 16th 07 11:18 PM
how to reset form pywhacket Excel Worksheet Functions 1 March 17th 06 02:54 PM
Clear"Reset" data input. Frick Excel Worksheet Functions 1 March 10th 06 11:40 PM
How can I have an input form to add a random no. to each input entry? saziz Excel Discussion (Misc queries) 2 January 25th 06 11:46 PM
format cell from data input to output form Brad Stevenson Excel Worksheet Functions 2 May 19th 05 06:04 PM


All times are GMT +1. The time now is 05:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"