Help on Userform

[jei eusebio]

Hi Ninjas,

Working on a userform that is linked to a sheet in my excel workbook. What I basically need is that once I select a name on the userform then it would display other information about that person coming from the Roster sheet .. similar to a lookup .. then the information would then be saved to the Comment sheet after clicking on the save button along with the current time and date. I have attached the sample file for your reference.

PS - Call Type and Comment are manual inputs . .

Thank in advance guys!

 

[Hui]

Jei

Please see attached

You will see I used Named Formula to simplify a lot of the work

I also had to disconnect one of the References *(Date/Time Controls) from VBA as I don't use any other libraries

 

[jei eusebio]

Thanks a lot Hui!

 

[Istiyak]

Hi Hui..

Its not working on my system.

showing error on Combobox_Change() event on [Campaign] line

please suggest

 

[Hui]

Istiyak

Do you have 7 named Formula setup as below


Is the Combobox linked to the correct Name?

Have you stepped through it with F8?

What version of Excel are you using ?
It works fine in 2010, I don't have any other versions at present to test it on.

Have you made any changes ?

 

[Shafique Ahmed]

Dear Hui,
Please find attached excel file related to combobox and suggest me.

 

[Shafique Ahmed]

Dear Hui,
Please find attached excel file related to combobox and suggest me.

any one please help me. above attached file for your reference.

 

[Hui]

Shafique

I answered that question sometime on the weekend in the original post

Why are you posting the question again here which is someone elses post?