Contents of cell copied to another sheet in case combo box value is choosen

AA Arens

Guest

Posts: n/a

20th Nov 2006

I have a value range in a row (worksheet 1).
That range is listed via Data > Name and Validation on another
worksheet (2)

How to have the name of cell A1 of Worksheet 2 mentioned in Worksheet 1
if the particular value is choosen?

So:

Worksheet 1:

10
20
30 X
40

Worksheet 2 (cell A1 = "Table"):

I choose via combo box value 30.
Neigboring cell X changed into "Table".

Bart
Excel 2003

« Need help to call Compact & Repair Database command from a office VB script | Copying hyperlink in excel »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Not all cell contents copied	David	Microsoft Excel Misc	5	11th Jan 2008 11:59 PM
Value copied based on choosen value from combo box	AA Arens	Microsoft Excel Discussion	3	3rd Dec 2006 04:50 PM
Worksheet_Selection Change code will not allow cell contents to be copied and pasted onto the sheet it's running on	KimberlyC	Microsoft Excel Programming	1	8th Jul 2005 02:51 AM
How can I allow only cell contents to be copied but not formatting	=?Utf-8?B?TWFydGluX29mX1V4YnJpZGdl?=	Microsoft Excel Programming	0	10th Mar 2005 03:23 PM
Do not select sheet and clear contents of copied cells	Chris Akens	Microsoft Excel Programming	3	9th Mar 2004 04:44 PM