Variables and formating

[keeegs]

Hi All

At the moment I have a macro that prints out a label depending on the information that is on a userform

My problem is that I have a date and it needs to me in the format dd-mmm-yy

At the moment I set the value from the DTPicker to a variable I4

The position that the date appears on the label can very depending on the type of the label.

Is there a way to set the format on the variable I4 so it doesnt matter what cell it is in?

Currently I am using:

ActiveCell.Offset(4, 1).NumberFormat = "dd-mmm-yy"

after I have put the data to a cell.

Any suggestions?

 

[keeegs]

The only problem is that the cell that the information is in changes.
So thats why I want the string to already be in the format dd-mmm-yy as the information is used multiple times depending on how many labels they want