What i want to do is make a marco that changes or adds units to a cell, that
allows the userer to enter the units desired.(by inputbox)

heres what i was trying, but i can get it to work

Dim x As String
x = ActiveCell.Formula
y = InputBox("What units do you want to input?", ("Unit Type?"), " CY")
x = "=" & x & " " & y
ActiveCell.Formula = x

origonally i had
x = ActiveCell.value
y = InputBox("What units do you want to input?", ("Unit Type?"), " CY")
x = "=" & x & " " & y
ActiveCell.value = x

but this took the number and not ther equasion so that further changes on
the sheet didnt update the column.

i recorded a macro doing this and it didnt help me much.
Please help!


Thanks!