Userform creation

Kiwi den

Board Regular
Joined
Feb 17, 2014
Messages
143
Office Version
  1. 365
Platform
  1. Windows
I am looking to create a userform that will search across many rows or columns depending on what is asked for
ie: database will have the following
A1 = Blue, A2= Weekly, A3= Texas, A4= 2019, A5 will have a jpeg picture
B1 = Red, B2 = Fortnight B3 = Maine, B4= 2020, B5 will have a jpeg picture
C1= Green, C2= Daily, C3 Iowa, C4 = 2020, C5 will have a jpeg picture

What I am looking for will be a search field in the user form , that if any of the data from A1 - C4 is entered then the entire row will be displayed including the relevant picture

if anyone can point me to where I can get tips or ideas on ho to achieve this would be very much appreciated
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
How many boxes on the userform ?
- ONE ?
- FOUR ? (ie colour, frequency, state, year)

Does your data look like this?
Book1
ABC
1BlueRedGreen
2WeeklyFortnightDaily
3TexasMaineIowa
4201920202020
5a picturea picturea picture
Sheet6



Which rows are visible if Green and Maine are entered in search box ?

Should search box contain dropdown ?
- is user allowed to type a value in search box ?
 
Upvote 0

Forum statistics

Threads
1,215,544
Messages
6,125,438
Members
449,225
Latest member
mparcado

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