Using data in a highlighted cell

12beavah · Apr 30th, 2002, 11:14 PM

OK this is what I am trying to do..

Have the user click on a cell,

Click on a macro button that will bring
up a simple promt box asking for a value.

Take the number from the input box and subtract it from the highlighted cell.

Then display the new number in the highlighted cell.

Any help on this would be great.
Thank you in advance.

Mark O'Brien · May 1st, 2002, 12:04 PM

Yup, I'd like to look at this just now, but I'm a bit busy.

My suggestion is to repost this in the "Excel Questions" section, this section is more of a general discussion of the site and suchlike.

Von Pookie · May 1st, 2002, 02:20 PM

Maybe we should lobby to get the explanations that are underneath each forum in a bigger font size...

May 1st, 2002, 12:04 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Yup, I'd like to look at this just now, but I'm a bit busy. My suggestion is to repost this in the "Excel Questions" section, this section is more of a general discussion of the site and suchlike. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

May 1st, 2002, 02:20 PM	#3
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Maybe we should lobby to get the explanations that are underneath each forum in a bigger font size... __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 11:14 PM	#1
12beavah New Member Join Date: Jan 2002 Posts: 2	OK this is what I am trying to do.. Have the user click on a cell, Click on a macro button that will bring up a simple promt box asking for a value. Take the number from the input box and subtract it from the highlighted cell. Then display the new number in the highlighted cell. Any help on this would be great. Thank you in advance.