16 replies to this topic

[travy92]

Well basically i want to change the text colour depending on what response is chosen, this is my code so far:

Private Sub cmdCountry_Click()
Dim strLocation As String
Dim Answer As Integer



strLocation = InputBox("Enter your Country:", "Country")

If Answer = Australia Then
frmTest.ForeColor = vbGreen




Print "Hmm, "; strLocation; " is a nice place to live."
Print "What State/Suburb do you live in?"
End If
End Sub
---------------------------------------------------------------

If Answer = Australia Then
frmTest.ForeColor = vbGreen

This is the part that changes the font colour when the response/answer is Australia.

This is perfectly what i wanted BUT i want to make it so that when a different response/answer is written (I'm using inputbox), a different colour is chosen. Without having to type out like every answer in the world!

Sorry if this was a newbie question.

Thanks in advance! :eek:

[o0TheNerd0o]

Select case...?

[o0TheNerd0o]

Select case example:

strLocation = InputBox("Enter your Country:", "Country")

Select Case strLocation
Case "Australia"
frmTest.ForeColor = vbGreen
Case "America"
frmTest.ForeColor = vbBlue
Case Else
frmTest.ForeColor = vbRed
End Select

[Lop]

Select Case would be your easiest answer. You will have to type out every answer you want colored though.

[travy92]

Alright thanks!

[TcM]

Or you could use if..then..else but case is more appropriate in this case I think.

[o0TheNerd0o]

It can definitely be done with "If", "ElseIF", "Else", but that method is not practical. Select case is the ideal solution for this sort of input handling.

[TcM]

Agreed. But most likely new people use if..then..else as they find it more logical and can figure it out easily, but of course case is the best solution.

[o0TheNerd0o]

But you can't stay new forever. Part of becoming a "good" programmer, is to learn more/new methods of doing the same thing. It makes you well rounded when it comes to theory and logic.

[TcM]

Yup, agreed.. Thats what I do. And always use the best method that I know of.

[o0TheNerd0o]

I think thats what everyone tries to do. I mean, if you know one way is better than the other, why would you use any other method?

It says you are a programming god. Do you have any actual programming experience? Anything credible? College? Work? Anything?

[TcM]

Well the 'programming god' thing just depends on your forum post count. And yes, I have actual programming experience I know some programming languages, made some custom-made softwares just for personal use, and personal use only, Had computer Studies and programming at school, and I had the best programming project at school (was ranked the first) and now I'm continuing to study at the college. I have some websites too and Besides Programming I have a very good general computer knowledge.