Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to create a macro to enter code via a Macro :
Sub Worksheet_SelectionChange(ByVal Target As Range) ' Enter code here via a Macro? End Sub If so how? I have copied the code to another module named Replace VBA. But how can i copy the code from there to the WorkSheet_SelectionChange event by a macro? I had a mass of code in the Worksheet_SelectionChange event, but found a copy/paste error was generated because some of the cells were also in the Worksheet_SelectionChange. So i figured(IF POSSIBLE), i could have the Worksheet_SelectionChange empty, until AFTER the Copy/Paste macro is run, then repopulate the Worksheet_SelectionChange with the code from the ReplaceVBA. Corey.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to enter a value, tab to next cell in the row, enter ... | Excel Programming | |||
Macro to enter a value, tab to next cell in the row, enter ... | Excel Programming | |||
NOT ABLE TO ENTER VB CODE | Excel Programming | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming |