Insert search and edit button

[rajesh nag]

Hi I Have created a macro with user form

Can any one help me to insert search and edit button to select added data from xl and edit

Kind regards
Rajesh

[figment]

this sounds like an easy task, but with data retreaval, knowing the layout of the data is 90% of the problem, if you could post a sample sheet with your user forum then people will be able to help.

[rajesh nag]

I have attached the file Please look into it

[figment]

try this

Attachment 7462

[rajesh nag]

Could u pls help me to insert a combobox where all the column name displays and a text box for seach criteria

If the data mataches in search text box with respect column then the list box shoul show only that row and all the details should be shown in text respective text boxes.

which help me to update the require data

[figment]

sorry about the delay in replying, yes i can do this. a few questions befor i start. can i sort the data? or dose it have to stay in the same location as it is? if i can sort the data, this will be quite easy, if not it will take a rewrite of most the functions.

[rajesh nag]

u can sort data

[rajesh nag]

Could u pls help me