Excel VBA Listbox on a Userform

[Andrrewc]

Hello,

I am just needing some help with a small piece of code...

I get the code working fine, except it will only do the first line after the THEN statement, however wont do the lines for text boxes 2 and 3. Should I be placing an AND statement or anything?

Many thanks,

Andrew

Please Login or Register  to view this content.

[cytop]

Excel VBA Listbox on a Userform

Where's the ListBox mentioned in the title?

[Andrrewc]

Hi Cytop,

For some reason I cant upload an attachment as an example, however I have included the whole code below which is linked to the update button on the userform. Essentially I am wanting the userform to edit the data in Sheet 1.

Cheers,

Andrew

Please Login or Register  to view this content.

[Andy Pope]

The IF code is working. The problem is the listbox control using a rowsource and you updating it. If you step through the code you will see that the first change of data on the sheet causes the listbox event to fire which updates the contents of the textboxes before their values have been update on the sheet

this should fix it.

Please Login or Register  to view this content.

[Andrrewc]

Thankyou very much for your assistance Andy, I understand what you have done, however I am now getting a "Compile Error Sub or Function not found" DO i need to define the store text or all or am I on the wrong track? Thanks heaps Andrew

[Andy Pope]

You need to declare the array that stores the values

Please Login or Register  to view this content.

I missed that in the posted code snippet

[Andrrewc]

Thankyou so much! Works perfectly...