I want to ask, if its possible to add a button into a excel spreadsheet such that when i click on it , it will reset selected fields to 0.
Please help,Thanks!
I want to ask, if its possible to add a button into a excel spreadsheet such that when i click on it , it will reset selected fields to 0.
Please help,Thanks!
Last edited by Yan Ni; 11-20-2012 at 03:35 AM.
yes it is possible. Can you attach a sample workbook?
Don't forget to mark your thread as [SOLVED].
Yan Ni,
This works:
Add a command Button. Edit the coe as below:
You can change the "A2:A6" to the range that you need. The "Range("A1").Select" line is just to keep the worksheet from highlighting the range all the time.Private Sub CommandButton1_Click Range("A2:A6").Select Range("A2:A6").Value = 0 Range("A1").Select End Sub
hth
Here's the sample, thanks!
what would you like to reset the value? those on below quantity?
Yup, i want both the quantity and the RSP to be zero when the button is pressed.
see attached file
Try this. hth
@Yan ni
Hi
Off course it is possible to add the buttons in Excel using with Form Control and Active X Control
for your 2nd thought you need to give some more details to us for reset the Number Range
Please see the Link Below
ThanksHTML Code:
Patnaik
Neither of what you both has provided has worked. I want row B and E to be reset to zero.
May I ask what worksheet do you need this macro because in the sample workbook that I gave you I put it in worksheets 2 put some values to it and then press reset you'll see if you need it to be in worksheets 1 please try this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks