combobox in a user form

[jsmity]

I've written a workbook that enables my workmates to enter sample information easily (workbook attached). What i need help on i cant get the combobox 's on the user form to pick up the related info in worksheet named "data" and insert it into the relavant coloumn in tab named "Results". I can get it to work without using combobox's and just typing the info into a textbox but i wanted to use combobox's.

Another thing i wanted to do was pick invidual results and send them the "Report" for printing. how would i do that.

Thanks in advance for your Help

[Macdave_19]

I have managed to get the comboboxes to populate buddy,

however i am unsure whatyou mean in terms of the report being printed individually can you clarify?

[jsmity]

thanks.....

The information in each row (1 row per sample) corresponds to the info on the REPORT. what i wanted to do was when needed sellect a particular row and then transfer to the report ready for printing or emailing

[Macdave_19]

I should be able to do that budd. leave it with me

[jsmity]

to further my knowledge could you include how you did it........

[Macdave_19]

Yeah ok, just look in the Code editor and i will put notes in there

[jsmity]

your a legend..... i'm starting a parttime VB course in september in a local college. it's intresting using VB to make tasks easier.

[Macdave_19]

Yeah i love using it and i pretty much do it for my job these days.

whats the course called and where are you taking it (might do it myself)

[jsmity]

its at pontypridd college its called - City & Guilds Introduction to Software Development

http://www.pontypridd.ac.uk/

[Macdave_19]

Here we go dude,

I added a second button where you select the ref number to be printed and then a box for the comments on the bottom.

it all works fine for m so i hope its ok for you.

Cheers

[jsmity]

thanks your a legend

[jsmity]

can you help with this ?

what i want to do is have a button (which i've got) that writes the report and then prints and a button that writes the report and then attach's the report to an email ?

How easy is this to do ?

I've attached the modded version of the file you helped with

[royUK]

It is really inefficient coding to Select ranges, sheets etc. Also, using a loop should be avoided as it will generally slow code. Here's 3 more efficient ays to populate your comboboxes

Please Login or Register  to view this content.

VBA macros can be extremely useful, but don't overlook non VBA methods. Your report can be filled without VBA just by using VLOOKUP. Give each Data entry a unique record number then get the information to populate the form by using VLOOKUP with that reference number.

[Macdave_19]

Yeah my coding isn't the best but i have to teach myself so at least it works hey roy lol!!

only one way to get better i guess and thats to learn.

Roy? you got any e-books that might help me?

[Macdave_19]

God you know it's annoying that sometimes you just can't see the simplest way of doing something, but now you mention it that would have been stupidly easy to do!!!

[royUK]

Dave we all have to learn this way, it's just great that the Internet helps like this. As for ebooks, I am halfway through one on excel databases.

[Macdave_19]

Yeah i totally agree,

i would be f'd if this forum didn't exist, but to be honset it's great when you learn a new function or piece of code and your mind starts wondering oround how you can use it all over lol.

as for the e-book, keep up the good work roy!

cheers