Focus from listbox selection to textbox gives an error

**Jovica** · 03-23-2014, 08:53 AM

I have a textbox3 for input value, and based on that value, if exist/correct focus is set on next textbox(12) if not listbox is populated with all values from a column (named range) and most similar value with that in textbox3 is selected in listbox.

After correct value is selected listbox can not unfocus. Every attempt to focus to any other object results in this error (Run-time error -2147467259 (80004005) Unspecified error).

And here is the code :

Please Login or Register  to view this content.

And

Please Login or Register  to view this content.

I've tried every combination that crossed my mind and everything resulted in same Unspecified error.

**AlphaFrog** · 03-23-2014, 02:56 PM

I don't see anything wrong with the code you've posted.

Just to confirm, you do have a Textbox12 (not Textbox2) ?

Do you have another procedure that sets ListBox1.SetFocus? Maybe there is a circular situation where one control's focus is set which in turn selects another control? Just a stab in the dark.

**LJMetzger** · 03-23-2014, 03:28 PM

Hi Jovica,

I could not duplicate your problem using Excel 2003.

I have two suggestions that have nothing to do with your problem:

a. Use Option Explicit. To prevent typos from ruining days and weeks of work you need 'Option Explicit' at the top of each code module.
This forces you to declare every variable.
http://www.cpearson.com/excel/DeclaringVariables.aspx

b. When you're done with the 'ws' (Worksheet) object, the object should be cleared:

Please Login or Register  to view this content.

See http://www.mrexcel.com/forum/excel-q...thing-why.html

Lewis

**Jovica** · 03-23-2014, 05:54 PM

I had to do a userform all over again, which is always a best solution (not the quickest) then I compare those two. I had cancel = true in textbox2 event and that was the problem, I don't know know what would that affect listbox since listbox tab index was after textbox 3, strange?

@ AlphaFrog I had to insert few textboxes in the middle of the form, that's why it's 12 after 3.
@ LJMetzger Thank you. I always forget Option Explicit. Also didn't know about Set ws = Nothing.

Once again thank you guys.

Focus from listbox selection to textbox gives an error

LinkBack

Thread Tools

Rate This Thread

Display

Focus from listbox selection to textbox gives an error

Re: Focus from listbox selection to textbox gives an error

Re: Focus from listbox selection to textbox gives an error

Re: Focus from listbox selection to textbox gives an error

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] UserForm - How To Make TextBox Value Change Depending On ListBox Selection

[SOLVED] Textbox focus

Multi select Listbox Items selection based on other Listbox item selection.

Textbox update with previous selection from listbox

[SOLVED] Retaining focus on a textbox / listbox item pair after validation = false.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions