Computer Name

**EDITTED - thought id did it in the first place**

I am looking a spreadsheet with userform to print labels.

I am looking at the same spreadsheet but the label printers are of three make and therefore have 3 different name. I am looking at using the Computer Name to pick the correct print name. Also looking at displaying the Computer Name on the Userform


Code so far

Please Login or Register  to view this content.

I think this should work but when tested no it didnt.. Please Help... Where am I going wrog?

Please put the code between code tags
Try the following instead of the first part

Please Login or Register  to view this content.

Welcome to the board, maclevey.

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with CODE tags.

Thanks.

EDIT: Thank you.

So: got it sorted?

How about ...

Please Login or Register  to view this content.

10-4 .