Difficult ------------- question

[Guest]

I write the macro like " CTN = inputbox("Pls input the no. of carton"),

when run the macro, the message "Pls input the no. of carton" will be shown
on

the screen, the question is how to enlarge the font size. I want the font
size shown

at 18 size or bigger.

 

[Gord Dibben]

InputBox has no font property to change.

Maybe a UserForm would better serve you?

http://www.contextures.on.ca/xlUserForm01.html


Gord Dibben MS Excel MVP