Search and select option inUserform

For an example. I have list of details in a sheet .

I need to select and search the values in userform. is it possible? how can we do?

Can you please help me on this.

click on the client_url from attached sheet and it will show you the list of client that i have.

But i want in a userform with search and select the value. if we are selecting any of the value, the url from another row
should get displayed in userform textbox.
Attached Files Attached Files

Not 100 % sure wat you want
The form CLIENT_UR was Emty

for start i put something in there


Kind regards
Leo

Hi Leo,

Thank you!! Thank You!! Thank you!!

This is what i expected. You have given more than what i expected.

Regards,
Praba

Ok Praba,

2 things i did to let it work you have to know

1 data in sheet2 start in A1, and there are no emty rows or columns.
2. there is an additional sheet, helper (hidden)

Cheers
Leo

Leo,

one more little change is required.

Actual : If i am clicking CLIENT_URL button from functionalities userform, its navigating to sheet2 where we have to
click one more button called userform to see the CLIENT_URL userform.

Expected : I dont want navigating to sheet2 , instead of that if am clicking CLIENT_URL button from functionalities userform it should
directly navigate to the CLIENT_URL userform which is created by you.

Thanks!!

Regards,
Praba

Praba

this for the button

Please Login or Register  to view this content.

Cheers
Leo

Thanks Leo.

From the same sheet, can we have any other attractive way for ParticipantStatus userform . Selecting the value from drop-down and corresponding answer will be displayed in a text box.

Regards,
Praba

Hoi Praba,

found 1 bug in previus, you not get thr good row number after use of the search field
this is solved in this 1

for the new question i changed the named range, it is now dynamic,
so you can add more rows


Kind regards
Leo

Thank You Muchhhhhhhhh Still lot of questions waiting for you

Hi Leo,

Below are the my requirements :

1. If am selecting the button from Withdrawal userform, another userform should display with my data (Instead of going to sheet),
2. Similarly for other userform also.

Aim is that, clicking the button and going to the sheet doesn't seems looks good. The data should displayed in textbox
from another userform

Please help me on this!

another userform should display with my data (Instead of going to sheet),

sheets are emty
cant create userform on emty sheets

Cheers
Leo

Leo,

i have the data in sheet, for an example if am clicking the any withdrawal button from withdrawal userfrom its navigating to a sheet. instead of that, userform should get display when clicking the withdrawal button with the data available in sheet

Hi Praba,

lot of sheets with only in 1 or 2 or 3 cells data
you have to ask yourself do i need all those sheets ?

also for the sheets you need, give them names,
see on userform1 wy


Kind regards
Leo

Hi Leo,

i am trying to save the data in target workbook and every time its showing " Do you want to save the changes that you made " (Target workbook)

i want the macro to auto save the target workbook.

Below the macro used :

Private Sub CommandButton1_Click()
Dim x As Workbook
Set x = Workbooks.Open("\\marrs\share\IS\Shared\Praba.xlsm")
Size = WorksheetFunction.CountA(Worksheets(1).Columns(2))
a = Size + 1
x.Sheets("Sheet1").Range("B" & a).Value = TextBox1.Value
x.Sheets("Sheet1").Range("C" & a).Value = ComboBox1.Value
x.Sheets("Sheet1").Range("D" & a).Value = ComboBox2.Value
x.Sheets("Sheet1").Range("E" & a).Value = ComboBox3.Value
x.Sheets("Sheet1").Range("F" & a).Value = ComboBox4.Value
x.Sheets("Sheet1").Range("G" & a).Value = TextBox2.Value
x.Close
End sub

Private Sub CommandButton2_Click()
Unload Me
End Sub

dont rememnber too lang ago