Advanced Userform to populate data from selection

[Sameer.k21]

Hi All,

Need help or suggestions on userform.

How can I auto populate the entries/data updated in the excel using the form.
Once the ID is selected from the list, it should auto populate certain fixed entries or data updated in excel the previous day.

Please suggest.

Thank you in advance.
Sameer

 

[Marc L]

Hi !

You can use Find method …

​

 

[Deepak]

Check this!

I have taken care of first multipage!!

 

[Sameer.k21]

Wow...This works awesome

 

[Deepak]

I am unable to get the follow up part !

Pls spare the time to explain the same how follow up will trigger & also data will populate on 2nd page.

Check this # i have did some more improvements:

 

[Deepak]

here ! One more

 

[Sameer.k21]

Hi, @Deepak Thank you so much for helping till here.

There 2 are different frames and NOT linked at all.

How do I get Frame2 SR# field to enable - this is behaving like data validation field.

 

[Deepak]

Leave the follow part! I will take it at last stage.

Check for rest others!

 

[Sameer.k21]

Superb this works and the rest are fine.

 

[Sameer.k21]

How do I get Email Triggerred on every follow up field in the UF. Submit cannot work for every single field in the UF. Right?

 

[Deepak]

Email will only sent to follow text box ?
There will total 4 emails? First on add/update to email textbox & after that each follow up textbox filling+ update?

 

[Sameer.k21]

That is correct. 4email triggers for page1 but this should work one at a time on different followup scenarios

 

[Deepak]

Pls send me the final one copy which u have.

 

[Deepak]

Check it.

Hope! You will trigger the rest. If not then post here with the issue.