Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying text via linked cell from combo box to macro code
Bearing in mind that I am certainly no more than intermediate leve Excel user, I wish to run a macro in the following way: a combo box has a linked cell, the user selects from combo box and th linked cell then contains text. As a macro (A), I copy this text int the code of another macro (B), and still in macro (A) I then run macr (B), reorganising my spreadsheet in the desired fashion. Also in A, return macro (B) to its initial state, allowing macro A to run again. When I actually try to do this, I either have trouble pasting th user's choice, the paste is there but inactive in the right clic department, or I get run time errors, with yellow highlighting or re text in the code of macro A. The macro code seems to use a "with...end with" reference type routin which is unfamiliar to me. I perhaps shouldn't be using a combo box, is there an alternative ? Th nearest analogy to it working I can think of is a user searching on website from a list of options. Select a, b, c, or d and the compute returns stuff relevant to a, b, c, or d -- pagelocato ----------------------------------------------------------------------- pagelocator's Profile: http://www.excelforum.com/member.php...fo&userid=1650 View this thread: http://www.excelforum.com/showthread.php?threadid=30432 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - Fixed text code needs replacing with variable text | Excel Discussion (Misc queries) | |||
forcing excel to update the Cell Link when copying Combo Boxes | Excel Worksheet Functions | |||
Macro linked to text or an object | Excel Discussion (Misc queries) | |||
Copying linked cell references. | Excel Worksheet Functions | |||
Copying/moving code in a macro | Excel Programming |