Posted to microsoft.public.excel.programming

external usenet poster

Posts: 64

Goal seek - column reference - user input message

What would be the code if i want to have a user input message box to
ask for column Y in macro below - thxs

Sub Goalseek()
'

Range("Y84").Goalseek Goal:=Range("AL84"), ChangingCell:=Range("Y50")

Range("Y85").Goalseek Goal:=Range("AL85"), ChangingCell:=Range("Y51")

Range("Y86").Goalseek Goal:=Range("AL86"), ChangingCell:=Range("Y52")
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
Goal seek - column reference	al	Excel Programming	3	January 25th 09 09:32 PM
Parameter Input for Goal Seek	Kro	Excel Discussion (Misc queries)	2	January 6th 09 10:16 AM
goal seek reference	SteveC	Excel Programming	2	September 14th 07 06:00 PM
goal seek circular reference	etxrmm	Excel Discussion (Misc queries)	0	March 16th 06 09:56 AM
Goal Seek - reference a cell for "To value" field?	cchristensen	Excel Worksheet Functions	1	November 5th 04 07:27 PM

All times are GMT +1. The time now is 02:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us