Range question

[JessyVal]

Hi, I have a question, I hope I can explain my self clearly

I have a form called userform1, this form is to show information about people , I can find them by id or by name, I can modify information from that form. As you can see, beside volunteer name box, there are two search buttons, if you click in the second search button a second user form is going to be displayed.

This is the second form, the porpuse of this second form is that in case the user is not sure about the id, or there are many people with the same name, he can pick which register is the one that he wants to update. The main idea is that the user click in the id, then click in Modificar (modify) and what I spected is that the first User form will be displayed with the info of the person that the user want to modify.

The issue that I am having now, is that once I click in the id and then press modificiar I got this error

this is the code that i have in the buttom Modificar (modify)

Private Sub CommandButton3_Click()
If Me.ListBox1.ListIndex < 0 Then
MsgBox "You haven't selected any record"
Else
UserForm1.Show
End If

End Sub

I hope I was able to explain myself

 

[Joe4]

You are getting that error because you have a "." in front of the word "Range" in ".Range("A1")".
Remove this period. You would only use ".Range" within a "With" clause, which you are not.
If it is not within a "With" clause, it would just be "Range"

 

[JessyVal]

You are getting that error because you have a "." in front of the word "Range" in ".Range("A1")".
Remove this period. You would only use ".Range" within a "With" clause, which you are not.
If it is not within a "With" clause, it would just be "Range"

It works! thankyou so much!

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[JessyVal]

You are welcome.
Glad I was able to help!

Hi Sorry, I dont't know why if I run the form from vba works well, but If I try to excecute from the excel sheet, I got an error

 

[RoryA]

It means that your form is already displayed, so you can't show it again.

This is also a different question really and should be posted as such.