Userform Help

[officeexcel2003]

Hello,

could you help me to configure this userform for Excel2003, please?

I want to use this userform but I don't know VBA.

Download here: Help.xls

Thank you very much.

[Mordred]

When you say it doesn't work for you, what is it that doesn't work?

[officeexcel2003]

I don't know where the failure of the code is.
I'm here because of that. I don't know how i can find out where the failure is and how I can configure this.

[Mordred]

With the workbook you have provided there is no sheet as per the following line of code

Please Login or Register  to view this content.

There is no data to fill the any of the objects within the user form so it is very difficult to tell where an error may be other than previously stated. Can you provide a mock workbook with mock data in it (no sensitive data nor personal information)? If you do that someone here should be able to help you.

Regards:

[officeexcel2003]

With the workbook you have provided there is no sheet as per the following line of code

Please Login or Register  to view this content.

There is no data to fill the any of the objects within the user form so it is very difficult to tell where an error may be other than previously stated. Can you provide a mock workbook with mock data in it (no sensitive data nor personal information)? If you do that someone here should be able to help you.

Regards:

Thank you very much Mordred. I have provided a mock workbook with mock data in it.

[royUK]

Please don#t quote whole replies.

I can't open the file.

[officeexcel2003]

Hello Roy,

I can open it. Why can't you open the file?

[royUK]

It opens now so what need sconfiguring - it should work in any version of Excel

[officeexcel2003]

I've now learned that the data entry does not work because the textboxes and comboboxes of the userform doesn't match with the cells of excel and the listbox don't show the entries.

I don't understand which textbox is for which cell and how to match the form with excel.

[royUK]

You need to go through the code & check what the textboxes are doing

Who wrote the code?

[royUK]

Given your problems & lack of VBA knowledge why don't you try selecting any cell within the data then open the Data menu & click Form

[officeexcel2003]

My colleague wrote this code and she is not more working.
I have to use this Userform and she can't say to me how it works or what do to.

I'm very unhappy because I hoped to find help here but I see it is not simply for you to adjust this code.
I don't know anybody who can help me with VBA and so I hoped to find help here.

I would be very happy if somebody could try to find out how to do this.

[royUK]

Your UserForm has

241 lines of code
24 Procedures
53 Controls

A big project to check this on a free Forum. Also, basically the code is inefficient & the code would need major re-writing.

This is too big a project to expect us to da all the work on

[officeexcel2003]

Thank you. I hoped to find the help here.
If somebody would like to do this big project, I would be very happy.

[officeexcel2003]

Is there anyone who knows VBA and could programm this?