LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default execute a macro from a dialog box on enter

in lotus i use .. aj.macrorun at the end of the code.. but in excel i do not
know the code to do the same..i want to run a macro which copys from a1 and
puts it in d1 so if i use a dialog box and put my name ..johnny and press
enter it should put johnny in a1 then the macro will copy from a1 and put it
in d1 when i press enter from the dialog box i can use two buttons and it
will work but i only want one but when i use the code together it does not do
the same as two seperate buttons this is whay i want to run the second from a
macro
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
code to execute on enter sc Excel Programming 2 March 19th 07 06:10 PM
Enter a new name in the Name Conflict dialog box giloboy Excel Worksheet Functions 0 November 9th 06 08:24 PM
macros doesn't execute unless i go into cell and press enter. Emma Excel Discussion (Misc queries) 2 October 20th 06 05:12 PM
ENTER keys to execute code to add menu Mark Warner[_2_] Excel Programming 1 August 25th 06 10:25 PM
Using VBA to enter info on external dialog box ChrisBat Excel Programming 0 April 30th 04 03:33 PM


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"