#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Macro

Hello
When recording a macro how do indicate that I want to type
information at this point each time the macro runs?
Thank you
Basil


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,533
Default Macro

Hi Basil

That can not be done while recording a macro.
You have to add an inputbox statement after recording. And tell the macro
what to do with the input.

HTH

Per



"basil" skrev i meddelelsen
...
Hello
When recording a macro how do indicate that I want to type
information at this point each time the macro runs?
Thank you
Basil


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Macro

Thank you HTH
What I wanted to do was open a web site and enter a password with
out having the macro remember the password so I have to enter it
each visit. I old 123 you pressed a key to tell it I want to do this
typing each time.
I will work with the input box and see how it works out
Basil
"Per Jessen" wrote in message
...
Hi Basil

That can not be done while recording a macro.
You have to add an inputbox statement after recording. And tell the macro
what to do with the input.

HTH

Per



"basil" skrev i meddelelsen
...
Hello
When recording a macro how do indicate that I want to type
information at this point each time the macro runs?
Thank you
Basil




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,533
Default Macro

Hi Basil

Thanks for your reply.

Regards,
Per

"basil" skrev i meddelelsen
...
Thank you HTH
What I wanted to do was open a web site and enter a password with
out having the macro remember the password so I have to enter it
each visit. I old 123 you pressed a key to tell it I want to do this
typing each time.
I will work with the input box and see how it works out
Basil
"Per Jessen" wrote in message
...
Hi Basil

That can not be done while recording a macro.
You have to add an inputbox statement after recording. And tell the macro
what to do with the input.

HTH

Per



"basil" skrev i meddelelsen
...
Hello
When recording a macro how do indicate that I want to type
information at this point each time the macro runs?
Thank you
Basil





Reply
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
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 1 February 5th 07 09:31 PM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 3 February 5th 07 08:22 PM
using a cell value to control a counter inside a macro and displaying macro value ocset Excel Worksheet Functions 1 September 10th 06 05:32 AM
Macro needed to Paste Values and prevent Macro operation thunderfoot Excel Discussion (Misc queries) 0 June 10th 05 03:38 PM


All times are GMT +1. The time now is 03: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"