Excel Database userform
4856
$$
- Posted:
- Proposals: 4
- Remote
- #47411
- Archived
Description
Experience Level: Intermediate
Hi all, what i am after is a excel userform and in that form i require
Part ref, Part Description, Product group number, Product Group Name, Unit Price, Install Time, Unit Of measure eg each length metre, and a search box,
when you enter a description or part description it then lists them in a box below say it has selected 10 item if you click on the selected item on line 3 this then populates the boxes,
at that point i need to have the ability to edit, delete, that item in the database also from the same userform i need to be able to insert a product.
in the userform when the product has been selected and has populated the boxes i need to be able to load product to active sheet by find last line used then add it to next line (check the lines used in description)
as i also allow free format insert in these lines.
Active sheet insert start point
D26 = Part ref E26 = Description, G26 unit price, H26 = install time
the input is from row 26 to 225 and i have 10 sheets the same so if userform command button is on each sheet
that sheet would be the active sheet
also in the user form i would like to be able to search via product group name and list all item associated to that product group
Active sheet column size and font
(D column width 16, Arial 10 font)
(E column width 56, Arial 10 font)
(G column width 13, Arial 10 font)
(H column width 13, Arial 10 font)
The sheet that holds all the data from the userform will be called “Database”
Thanks
John
Part ref, Part Description, Product group number, Product Group Name, Unit Price, Install Time, Unit Of measure eg each length metre, and a search box,
when you enter a description or part description it then lists them in a box below say it has selected 10 item if you click on the selected item on line 3 this then populates the boxes,
at that point i need to have the ability to edit, delete, that item in the database also from the same userform i need to be able to insert a product.
in the userform when the product has been selected and has populated the boxes i need to be able to load product to active sheet by find last line used then add it to next line (check the lines used in description)
as i also allow free format insert in these lines.
Active sheet insert start point
D26 = Part ref E26 = Description, G26 unit price, H26 = install time
the input is from row 26 to 225 and i have 10 sheets the same so if userform command button is on each sheet
that sheet would be the active sheet
also in the user form i would like to be able to search via product group name and list all item associated to that product group
Active sheet column size and font
(D column width 16, Arial 10 font)
(E column width 56, Arial 10 font)
(G column width 13, Arial 10 font)
(H column width 13, Arial 10 font)
The sheet that holds all the data from the userform will be called “Database”
Thanks
John
John H.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
10 Dec 2010
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies