Input box

[shaz123]

Is it possible to change an inputbox, showing the yes and no option instead of OK and cancel?

 

[SgtJarrow]

Why? If you need to ask a Yes/No type question, use a MsgBox instead.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[shaz123]

Well the thing is depending on if the user clicks on yes or no button i needed to input some information into a table. How would u refer to a button on the msgbox.

 

[SgtJarrow]

OK...so you are asking the user a question and need to do something based on their response.

If MsgBox("Do you wish to continue?", vbYesNo, "Continue?") = vbYes Then
    'Do something here
End If

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[mp9]

If MsgBox("Your question?", vbYesNo+vbQuestion) = vbYes Then
'Do your Yes stuff
Else
'Do your No stuff
End If

http://www22.brinkster.com/accessory/

 

[shaz123]

thankyou, i will try it out