I'd like to make a one command button for which the function on Sheet "PM Data" (when pressed) would:
1--Reset Cells (G5, G28, and G51) to a default value of "2",
2--Reset Cells (D16, D39, and D62) to a default value of "C/D"
Can anyone help me w/ the steps from beginning to end? Thanks!!!
Last edited by VBA Noob; 02-18-2009 at 06:41 PM.
Sure thing, I'll put a sheet together for you with an explanation of the VB on it.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Please Login or Register to view this content.
See attached sheet.
Text explanation on the sheet with instructions on how to make your own, and how to look at the code already in that one, and instructions in the code on how it works.
mew!
Re: Command Button To Reset Values
Does the code you provided not allow for a certain number of cells within the range? In other words can I insert 45 cells into each range?Originally Posted by Kenneth Hobson
Please Login or Register to view this content.
You could enter them individually, but I don't think it'll allow you to declare a range that large. You could just do like 5 on each line though.
Re: Command Button To Reset Values
Thanks sooooooo much! U R great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks