PDA

View Full Version : User form Help



Svmaxcel
09-29-2017, 12:22 AM
Attaching 2 files here
User form file has a form with several fields.
Grey column should update values in User form
Pink column should update values in Sheet.

I want to start User form as soon as user click on Audit Done column.
So if user click on Audit done in Row 2, User form should react with Row 2 data and so on.

Aussiebear
09-29-2017, 02:16 AM
What populates the cells of the active row O to AD

Svmaxcel
09-29-2017, 03:42 AM
When I click on col M let's say M2.
User form should open and autofills Row 2 data like.
Emp Name
CITRIX I'd
Team Manager
Avaya I'd
Skill
Language
Score
Call date
Call time
Account Number.

Svmaxcel
09-29-2017, 03:43 AM
What populates the cells of the active row O to AD

Kindly refer to event sheet. It has events, dsat drivers..

Svmaxcel
09-29-2017, 10:05 PM
I used userfoem.initialize and was able to get it working.
Have issue with combo box conditions based on selection

Bob Phillips
09-30-2017, 12:23 AM
You will have issues if you don't write any code.