Jump to content

MsgBox variable help needed


Go to solution Solved by Melba23,

Recommended Posts

Posted (edited)

Hi all,
 
Need some help with line 3:

Local $var = InputBox("Macro", "Type macro to get value:")

MsgBox(0, "Macro Reference", "Macro: " & $var & @LF & $var)
;MsgBox(0, "Macro Reference", "Macro: @YEAR" & @LF & @YEAR)

If I run code and enter "@YEAR" in the inputbox I don't get the year.
How do I get the $var at the end to output the year? I want the output to look like line 4.
 
Thanks

Edited by Runner
  • Moderators
  • Solution
Posted

Runner,

Use Execute: :)

$var = InputBox("Macro", "Type macro to get value:")
MsgBox(0, "Macro Reference", "Macro: " & Execute($var) & @LF & $var)
M23

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:

  Reveal hidden contents

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...