Userform, IF-function

[The Student]

Hi
Can someone see why this doesn´t work.
If I choose a certain element in the first Userform1, I like another to pop-up (Userform2) unless I pick the value that become True.

Even if the value in "A11" become TRUE it will still show Userform2. I don´t know why.

Sub Choise()

Userform1.Show

If Range("A11").Value = "TRUE" Then
Sheets("XXX").Select

Else
Userform2.Show

End If

 

[KOKOSEK]

"TRUE" or True?

 

[The Student]

"TRUE" or True?

"TRUE" or True?

TRUE

 

[The Student]

"TRUE" or True?

It works if I change "TRUE" to a number, but is it not possible to reference a cell value named "TRUE" ?

 

[KOKOSEK]

"TRUE" - is a text 'TRUE'
True - is a boolean
What type of result appear in A11?

 

[The Student]

"TRUE" - is a text 'TRUE'
True - is a boolean
What type of result appear in A11?

Its the "TRUE" value that appear in A11 if the user have chosen that in the Userform. Otherwise it becomes FALSE.

That way I can change the Userform they see depending on their choises.

 

[Fluff]

What is the name of the sheet you want to check A11

 

[The Student]

It´s the active sheet.
I have called it "Data"

I believe the problem is the TRUE value, because excel sees it as a boolean.
It works if I change it to another value.

 

[Fluff]

Its the "TRUE" value that appear in A11 if the user have chosen that in the Userform.

How will it appear in the cell?

 

[The Student]

How will it appear in the cell?

It appear like this. (See picture).

If the user don´t select that option in the userform, it will become FALSE (FALSK) and another cell in my Data-sheet will become TRUE.

I´m Danish, so SAND=TRUE