Results 1 to 2 of 2

Thread: Pass a string to a Excel Macro??

  1. Oct 30th, 2002, 05:43 PM #1
    texas
    texas is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2001
    Location
    Austin
    Posts
    397

    Pass a string to a Excel Macro??

    Is it possible to pass a sting to an Excel Macro?


    I can open the macro but I can't pass a sting to it.
    Reply With Quote Reply With Quote
  2. Oct 31st, 2002, 05:32 AM #2
    JordanChris
    JordanChris is offline
    Frenzied Member
    Join Date
    Jan 2001
    Location
    Newbury, UK
    Posts
    1,878
    You can't call the macro with a parameter??
    OR
    You can't specify in the macro that a parameter has been entered??

    If you put

    Sub Macro1 (myString as String)

    then the macro will be expecting a parameter.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width