UserForm: Textbox value load according to drop down list

[lazyserv]

Hi gurus,

I have a userform that I need it to load the value in the textbox according to the dropdown list

For example:
If outlet ABC selected, it 3 textbox need to show the value in same row of ABC outlet.

Beside that, there is two button I need it to function as well

Save button:

Save the textbox value according to the drop down list selected

For example, ABC outlet selected and there if there is a changes of any 3 textbox, say Promoter name change from David to Dave the save button need to save according to the cell selected

Delete button:

Need to delete whole row of selected outlet

Please refer attached file: New Book.xlsm

May I know how to achieve this?

Thank you.

[lazyserv]

i found this more or less the same situation from:

http://stackoverflow.com/questions/2...using-named-ra

and I modify it to suit my current condition:

Please Login or Register  to view this content.

but it seems doesnt work with my multiple textbox

[MarvinP]

Hi lazyserv,

Find the attached where I've triggered your userform by a double click in Column A. Then look at the code behind the Setup form for the On_Change code. Each time you change the combo dropdown it will refresh the data. You can also now change an outlet name and it will add it to the list when you click on the save button.

I hope this little example gives you some ideas on how to use uerforms and their events.

[lazyserv]

Hi MarvinP

May I know is it possible for it to load on the form Load?

Currently I need to double click column A to show the form.

Can change it to when I click a button that use Macro to call the form?

For example: I create a button name Show Form

Please Login or Register  to view this content.

Once the form load it will show default ABC outlet.

[lazyserv]

In addition:

How do I save the code to Accounting format for this code row?
I already set the whole row in Accounting format

Please Login or Register  to view this content.

Currently when Initialize I set the format to load as Currency style

Please Login or Register  to view this content.

But when I save the form it show as number instead of accounting format

[MarvinP]

Try this one.

[lazyserv]

it work like charm, but it doesn't save the cost as accounting format

it just save as number, if you look at the book all the cost was set to accounting format

[MarvinP]

I don't quite understand what you want with "save in accounting format".

Maybe the text needs to be changed to numbers before saving? 6 the number and 6 the letter both look the same to us but Excel treats them differently. Perhaps a convert to number using VBA is what you need somewhere in your code? Perhaps a .Value or CDec() is needed on that last textbox before you stick it back on your worksheet?

[lazyserv]

My apologize, I didnt notice the code should end .Value

I added the code and now it work like charm!

Thanks and +rep for solving my problem.

Thank you!!!

[lazyserv]

Try this one.

Hi MarvinP

May I know how can I delete the whole row based on the drop down list selected?