sam05hart
08-05-2018, 04:51 PM
Hello,
I am a very new and basic user of VBA so thank you ahead of time for your patience. I would like be able to use option boxes to dictate what will be searched and what will populate in my cover sheet. For example, if I have "Type" pressed and put "200" in the text box and hit search all of the results with type 200 will show up on the cover page. Right now I have the VBA code that pulls up the "Part Number" but that is not linked to the option buttons, those are just for show. As I am brand new to this forum please let me know if you will be needing additional information. Any and all information would be beneficial.
Please see the attachment for clarification.
Thanks,
I am a very new and basic user of VBA so thank you ahead of time for your patience. I would like be able to use option boxes to dictate what will be searched and what will populate in my cover sheet. For example, if I have "Type" pressed and put "200" in the text box and hit search all of the results with type 200 will show up on the cover page. Right now I have the VBA code that pulls up the "Part Number" but that is not linked to the option buttons, those are just for show. As I am brand new to this forum please let me know if you will be needing additional information. Any and all information would be beneficial.
Please see the attachment for clarification.
Thanks,