Input box with checkmarks

[ThatGuyNamedDean]

I am trying to create an input box that has an either/or type check box along with the standard input box. The user has to input a temperature and I would like to give them the opportunity to input in degC or degF and have the program make any of the necessary calculations before the number is used as part of a graph. I'm not sure if this function is even possible so any help or recommendations would be greatly appreciated. Thanks!

 

[davesexcel]

You need to create a userform

 

[JoeMo]

I am trying to create an input box that has an either/or type check box along with the standard input box. The user has to input a temperature and I would like to give them the opportunity to input in degC or degF and have the program make any of the necessary calculations before the number is used as part of a graph. I'm not sure if this function is even possible so any help or recommendations would be greatly appreciated. Thanks!

If you want check boxes that requires a UserForm. Here's a way you can offer the user a choice and still use an InputBox function. Comment out the message boxes which are there to show you what the Val function returns.

Sub CorF()
Dim ans As Variant
ans = InputBox("Input temperature followed by F or C as 98.6F")
If ans = "" Then Exit Sub  'user clicked Cancel
If ans Like "*F" Then
    ans = Val(ans)
    MsgBox ans
    'do calculations for Farenheit
ElseIf ans Like "*C" Then
    ans = Val(ans)
    MsgBox ans
    'do calculations for Centigrade
End If
End Sub

 

[Mike LH]

Hi,

That would be very simple to do in VBA using a userform. You would create a userform with a textbox for the input and 2 option buttons for F and C and a command button. I made one for you and it's on my onedrive link below. It's called Degc_DegF

It will need some polishing but it gives you the idea.



https://onedrive.live.com/?cid=66A66EA84229B01B&id=66A66EA84229B01B!108

 

[ThatGuyNamedDean]

Thank you Joe and Mike. I have implemented the input box technique right now and as I start to become more familiar with userforms this will be the 2.0 version of the workbook. Thanks!