LinkBack URL
About LinkBacks
Hi,
I am looking to build a userform in which i have a combobox, this will let me select the customer i want and when pressing ok will get data from the same sheet regarding the customer and putting it on to my report worksheet.
Regards,
James
Hi,
I am looking to build a userform in which i have a combobox, this will let me select the customer i want and when pressing ok will get data from the same sheet regarding the customer and putting it on to my report worksheet.
Regards,
James
Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Sixth,
So in the before worksheet i have all the source data but this has not been filtered. what i want to do is go into the after worksheet press a button which will open a user form, and i can select which company press ok and will pull the relevant data which i have labelled, leave completeness as i will do that after.
Report.xls
Last edited by jashton154; 10-16-2013 at 05:44 AM.
Thanks for the file.
Instead of going for a combo box in userform approach why don’t you keep a cell for selecting the cells? Just use a Validation List for that cell so that you can select the company names from the cell list?
Whatever you feel is going to work better, would you be able to do this and show me an example ?
Sixth,
That sheet is an example there will be 200 plus companies involved
Also I will need to be told how to put it into the real excel workbook
Please add some company names and the Userform with list and expected output for one company in a sheet. and attach the file So that I can able to proceed further…
Sixth,
If you look in After worksheet you will find the end product, so i want to be able to select a company from the before sheet either via userform or just a combobox, and when selected the data for that company to be pulled out as shown in after sheet.
Report after.xls
Refer the attached file for details... Just open the workbook and Press Alt+F8 and Select ShowUserform and run the code...
Please Login or Register to view this content.
Sixth,
Thats perfect mate, the only thing is now how do i copy and paste the company name into all relevant lines as i have like 200 companies.
also how do i add people to the list.
It will auto adjust based on the formula used in the sheet1 and which is referred to named range CompanyNameList and the named range is referred in combo box rowsource. So no need to worry about it since it is an automated process...Originally Posted by jashton154
Refer the below links to know how...
http://www.contextures.com/xlDataEntry02.html
http://www.extendoffice.com/document...lue-above.html
Thanks Mate,
Im adding data into the before sheet but not coming up in the user form or sheet 1 im adding them after poppy ltd so they will be 5th company
Just extend the range of the Sheet1 A2 cell formula since I have referred it to the used range of Column-A of Before sheet...
sorry about this mate, doesnt seem to work for me would you be able to send a formula? my last row is A2487
It is an array formula so after extending the $A$152 to $A$2487 you have to enter it with - CTRL+SHIFT+ENTER
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
Thanks mate, in the userform list i am only getting the 100 rows you put in but i have 100+ so in the drop down only showing 100
Just extend the sheet1 column A formula to 100+++ rows
i have but its not showing them after 100 in the list on the userform.
Check whether is there any number of line items settings in combobox property, since I am in travelling without access to system so unable to check it. Giving reply from mobile device. Possibly I will look it by tomorrow that is after 12 hours.
rowsource is companylist would i have to update that?
No boss dont touch tat property...
See something like display number of line items property like that...
Sixth,
i still can not find the solution where the userform shows more than 100 companies. this is my new file.
Regards,
James
Report after_Userform With Code1.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks