sarasotavince
New Member
- Joined
- May 14, 2011
- Messages
- 24
Hello. I am an entry-level VBA code monkey who is about to take on a more ambitious project. However, I am first seeking a few opinions as to whether or not VBA can actually do what I want it to do. I know VBA is wonderful and this seems fairly reasonable--I just don’t want to beat my head against the wall if this can’t be done. Here is the set up.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have several hundred pieces of equipment on a sheet called INVENTORY. Some examples would be as follows:<o></o>
<o></o>
#1234 Truck,Pickup ½ Ton Ford 2 Door<o></o>
#2345 Truck,Pickup 1 Ton Chevy 4X4 <o></o>
#7654 Truck, Pickup 1.5 Ton Toyota Club Cab<o></o>
#0099 Truck, Dump 8 CY Sterling Diesel<o></o>
#1289 Truck Dump 12 CY Ford Gas<o></o>
=============<o></o>
User opens the workbook….is prompted to enter some basic information, name, address, phone number and “What type of equipment are you looking for?” This requires the user to enter a key word so a search can begin (command button). Let’s say the user enters “TRUCK.” I want VBA to search the INVENTORY sheet (col B) and every time the word TRUCK is part of the description I want to flag those rows, then take those rows and display the full description of each matching item (maybe 4 or 5 columns for each piece of inventory) in a pop up userform with an option button next to each item so that after the user reviews all the items that match the basic description of TRUCK, the user can select the one they want. After a selection is made, that exact piece of equipment will populate in 4 or 5 text boxes on the main form that will be part of the user’s profile.<o></o>
So in the end, the worksheet once printed might look like:<o></o>
Tony Smith<o></o>
1123 Mocking Bird Lane, Columbus, OH<o></o>
614-123-4567<o></o>
I would like to see:<o></o>
#0099 Truck, Dump 8 CY Sterling Diesel<o></o>
<o></o>
Without writing any code to solve the above problem, I am seeking your expert opinion. Can such a thing be done with VBA? If so, where I will need some help (down the road) is completing the search, taking the matching items and displaying them in the user form with an option button by each piece of inventory, then taking the unique item and populating some text boxes on the main userform. Otherwise, I think I can manage the before and after stuff according to my description above.<o></o>
<o></o>
Hey, thanks in advance for any consideration to this potential future project. If I have not been clear, please ask any follow up questions and I'll fill in the gaps.<o></o>
I have several hundred pieces of equipment on a sheet called INVENTORY. Some examples would be as follows:<o></o>
<o></o>
#1234 Truck,Pickup ½ Ton Ford 2 Door<o></o>
#2345 Truck,Pickup 1 Ton Chevy 4X4 <o></o>
#7654 Truck, Pickup 1.5 Ton Toyota Club Cab<o></o>
#0099 Truck, Dump 8 CY Sterling Diesel<o></o>
#1289 Truck Dump 12 CY Ford Gas<o></o>
=============<o></o>
User opens the workbook….is prompted to enter some basic information, name, address, phone number and “What type of equipment are you looking for?” This requires the user to enter a key word so a search can begin (command button). Let’s say the user enters “TRUCK.” I want VBA to search the INVENTORY sheet (col B) and every time the word TRUCK is part of the description I want to flag those rows, then take those rows and display the full description of each matching item (maybe 4 or 5 columns for each piece of inventory) in a pop up userform with an option button next to each item so that after the user reviews all the items that match the basic description of TRUCK, the user can select the one they want. After a selection is made, that exact piece of equipment will populate in 4 or 5 text boxes on the main form that will be part of the user’s profile.<o></o>
So in the end, the worksheet once printed might look like:<o></o>
Tony Smith<o></o>
1123 Mocking Bird Lane, Columbus, OH<o></o>
614-123-4567<o></o>
I would like to see:<o></o>
#0099 Truck, Dump 8 CY Sterling Diesel<o></o>
<o></o>
Without writing any code to solve the above problem, I am seeking your expert opinion. Can such a thing be done with VBA? If so, where I will need some help (down the road) is completing the search, taking the matching items and displaying them in the user form with an option button by each piece of inventory, then taking the unique item and populating some text boxes on the main userform. Otherwise, I think I can manage the before and after stuff according to my description above.<o></o>
<o></o>
Hey, thanks in advance for any consideration to this potential future project. If I have not been clear, please ask any follow up questions and I'll fill in the gaps.<o></o>