userform

[devendra.dvm]

good morning Monty.

i have checked ur file...uploading working perfectly....but that column "A" is not required in output sheet...and in that user form Agent filed "agent code" should get select automatically...as i want to apply rates for multiple agents.

 

[devendra.dvm]

how to open user form again once i hit exit button.

 

[Monty]

Hold on for more...will respond tonight.

 

[devendra.dvm]

thank you..

 

[devendra.dvm]

Hi Monty Gud eveng..

 

[devendra.dvm]

hi monty...hope u vl reply..

 

[Monty]

how to open user form again once i hit exit button.

Hello Devendra

Please find attatched for your question , how to open user form again once i hit exit button.

 

[Monty]

Hello ArpanaKumar

Thanks for giving your likes!

Hope this helped you!

 

[devendra.dvm]

hi monty..thanks for reply...but there is no attachment here..can u pls send it again

 

[Monty]

Sorry for that..Now you can check!

Let's take step by step your question.

 

[devendra.dvm]

hi monty... thank u...got the file..everything is perfect in uploading part..

1.column-A is not required in output sheet...

2.In user form Agent codes will b multiple so i required any table or dropdown in upload sheet to select multiple agents..

 

[Monty]

You mean this highlighted is not required on userform!
or
you need combobox to select agents

 

[Monty]

This is what you are looking for "Agent"

 

[devendra.dvm]

no no that is required in userform...i am talking about output sheet..

 

[devendra.dvm]

yes but can i select multiple agent codes at the same time...

 

[Monty]

Am trying to understand!

from output sheet "A" column

once I hit apply agents out should be like this for broke type 1 and all fields should get clear so that I will update remaining broke types

 

[Monty]

yes but can i select multiple agent codes at the same time...

On userform you meen

 

[devendra.dvm]

Yes

 

[Monty]

For agents multiple selection!

 

[devendra.dvm]

if table like this will available in upload that would be better....i will paste multiple agents here so that wat ever i will update in other fields will get apply to these agents and i hit upload button

 

[devendra.dvm]

yes thats perfect monty

 

[Monty]

Check this below...Select from First list box single or multiple and click on Move selected button!

 

[Arpanakumar]

Monty Great going. I would need your help building forms for my project some time..Quit interesting.

 

[devendra.dvm]

yes..thats perfect

 

[devendra.dvm]

gud morning.. monty if possible pls share the file.