i am using a inputbox function in my excel sheet to input values
Dim I As Integer
Dim str As String
'InputBox(Prompt[,Title][,Default][,x][,y][,HelpFile][,HelpContextId)][,Type])
str = Application.InputBox("This is a test", "Demo", Type:=2) ' title and default understood
so far this works fine.
But i wanted to know what is xpos and ypos and how or what values to be assigned
can i make a word file on my desktop and connect that as a help file so that users can just click and refer them while inputting the references
Can some one tell me how to use the last for options xpos, ypos,helpfile,helpcontextid.
I have searched lot of sites for info they only say as optional parameters and not much examples on that subjects.
many thanx
Bookmarks