Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros inside macros, and pasting into macro code.
Bearing in mind that I am certainly no more than intermediate level 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 the linked cell then contains text. As part of macro (A), I copy this text into the code of another macro (B), and still in macro (A) I then run macro (B), reorganising my spreadsheet in the desired fashion. Also in A, I 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 the user's choice, the paste is there but inactive in the right click department, or I get run time errors, with yellow highlighting or red text in the code of macro A. The macro code seems to use a "with...end with" reference type routine which is unfamiliar to me. I perhaps shouldn't be using a combo box, is there an alternative ? The nearest analogy to it working I can think of is a user searching on a website from a list of options. Select a, b, c, or d and the computer returns stuff relevant to a, b, c, or d. -- pagelocator ------------------------------------------------------------------------ pagelocator's Profile: http://www.excelforum.com/member.php...o&userid=16506 View this thread: http://www.excelforum.com/showthread...hreadid=320019 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros inside macros, and pasting into macro code.
Not clear what you mean by copying text into a macro. Post the code for a
better response. -- HTH RP (remove nothere from the email address if mailing direct) "pagelocator" wrote in message ... Bearing in mind that I am certainly no more than intermediate level 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 the linked cell then contains text. As part of macro (A), I copy this text into the code of another macro (B), and still in macro (A) I then run macro (B), reorganising my spreadsheet in the desired fashion. Also in A, I 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 the user's choice, the paste is there but inactive in the right click department, or I get run time errors, with yellow highlighting or red text in the code of macro A. The macro code seems to use a "with...end with" reference type routine which is unfamiliar to me. I perhaps shouldn't be using a combo box, is there an alternative ? The nearest analogy to it working I can think of is a user searching on a website from a list of options. Select a, b, c, or d and the computer returns stuff relevant to a, b, c, or d. -- pagelocator ------------------------------------------------------------------------ pagelocator's Profile: http://www.excelforum.com/member.php...o&userid=16506 View this thread: http://www.excelforum.com/showthread...hreadid=320019 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add the macros contained inside a template to an Excel file. | Excel Discussion (Misc queries) | |||
Exporting Time Formatted Numbers inside Macros | Excel Worksheet Functions | |||
Macros inside Excel | Excel Worksheet Functions | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming |