Help using a single cell data in a macro

[Mike_E]

Hello,

I am trying to figure this one out. The goal is, you press the macro buttons and a message gets input into the active cell with the date stamp and time stamp. The formula works, yay me! Now I need to make a section of it call from a specific sheet and cell, to make it user friendly for work. That is where I am stumbling.

The formula that works:

ActiveCell.FormulaR1C1 = "RLI 62486 " & Format(Now() "mm/dd/yyy hh:mm AM/PM")

What I need to do:

Call the 62486 part from cell A1 on a sheet titled User, so that anyone can enter a number there and the macro will use that instead.

 

[steve the fish]

Hi. In much the same way as you already have you build up the string by concatenating parts together:

ActiveCell.Value = "RLI " & Sheets("User").Range("A1").Value & " " & Format(Now(), "mm/dd/yyyy hh:mm AM/PM")

 

[Mike_E]

Thank you so much! Works like a charm!