Thanks Per,

These all work great - im learning alot about the coding for user forms.

All the best,

Roger



"Per Jessen" wrote:

Roger,

Add a Label to your userform and use this code:

UserForm1.Label1.Caption = "Select your comment for step " &
ActiveCell.Offset(0, -1).Value

Or if your want to display it as the caption of the userform:

UserForm1.Caption = "Select your comment for step " &
ActiveCell.Offset(0, -1).Value

Hopes this helps.

Best regards,
Per

"Roger on Excel" skrev i
meddelelsen ...
Per,

It would not be nescessary to add new user comments to the list.

I have modified the code so that a combo box (pointing to the comments
list)
is in the dialog. I did this by creating a new userform with command
buttons
to activate the code and close the form. It looks as though it works fine
as
I can now select the comment from the combo dropdown. However I would want
to
retain the label code that you had as I quite like seeing it state "Step
1,2,3 etc" in the dialog.

How would I make the label in the new userform state the step number - i
am
not sure how to do this in my newly created userform?

Best regards,

Roger