Have a look at this site - It shows you how to create a userform, add
controls like textboxes etc & even has a short video.
http://www.contextures.com/xlUserForm01.html
--
jb


"Miree" wrote:

If i do create a user form then how do i get it to use it instead of text box?


"The Code Cage Team" wrote:

An Inputbox isn't a UserForm its one of Excels built in boxes and as such we
cannot format it, if you were to create a userform to look like an InputBox
then you could size that as needed.

Regards,
The Code Cage Team
www.thecodecage.com/forumz

"Miree" wrote:

With the help of lovely forum peeps i have a piece of code which includes

Response = InputBox("Formulation Number", vbOKCancel)

Is it possible to format the inputbox, as its a little big and looks silly.

I have never used a user form so dont really have a clue where to start there