Seeking Expert Opinions -- Upcoming Project

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-com:office:office" /><o:p></o:p>
I have several hundred pieces of equipment on a sheet called INVENTORY. Some examples would be as follows:<o:p></o:p>
<o:p></o:p>
#1234 Truck,Pickup ½ Ton Ford 2 Door<o:p></o:p>
#2345 Truck,Pickup 1 Ton Chevy 4X4 <o:p></o:p>
#7654 Truck, Pickup 1.5 Ton Toyota Club Cab<o:p></o:p>
#0099 Truck, Dump 8 CY Sterling Diesel<o:p></o:p>
#1289 Truck Dump 12 CY Ford Gas<o:p></o:p>
=============<o:p></o:p>
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:p></o:p>
So in the end, the worksheet once printed might look like:<o:p></o:p>
Tony Smith<o:p></o:p>
1123 Mocking Bird Lane, Columbus, OH<o:p></o:p>
614-123-4567<o:p></o:p>
I would like to see:<o:p></o:p>
#0099 Truck, Dump 8 CY Sterling Diesel<o:p></o:p>
<o:p></o:p>
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:p></o:p>
<o:p></o:p>
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:p></o:p>
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,224,517
Messages
6,179,233
Members
452,898
Latest member
Capolavoro009

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top