Button in VBA code

[Annemus]

Hello
I want to know if it is possible to write on the botton's made in VBA code

Instead of YesNo bottons I want to write on the botton.

Right now I have this instead:

sType = MsgBox("Does the car drive on gas?", vbYesNo)
If sType = vbYes Then
Range("B5").Value = "Gas"
sType = "gas"
ElseIf sType = vbNo Then
Range("B5").Value = "Diesel"
sType = "diesel"
End If

Is it possible to write "What does the car drive on?", and then have to buttons with gas or diesel ??

Thanks

 

[Jaafar Tribak]

Hello
I want to know if it is possible to write on the botton's made in VBA code

Instead of YesNo bottons I want to write on the botton.

Right now I have this instead:

sType = MsgBox("Does the car drive on gas?", vbYesNo)
If sType = vbYes Then
Range("B5").Value = "Gas"
sType = "gas"
ElseIf sType = vbNo Then
Range("B5").Value = "Diesel"
sType = "diesel"
End If

Is it possible to write "What does the car drive on?", and then have to buttons with gas or diesel ??

Thanks

It is easier to use a custom userform with the two buttons .

 

[Ruddles]

Then you'd be able to use radio buttons if you wanted to.

 

[Annemus]

I am sorry.. I'm very noob at VBA, so I don't know that costum userform or radio bottons mean..

 

[Ruddles]

Radio buttons are... well, radio buttons. You know - radio buttons!

Forget those anyway - if you want a MsgBox with your own captions on the buttons you'll have to design a userform:-

I've just tried Googling excel userform msgbox and there are any number of examples of how to do this, all of them better than I could manage, I'm sure.

Try one or two of them and see how you get on. If you get stuck, come back to us.