Hi,

Recently, I've been struggling with user input dialog stuff, and I succeeded with the great help I received from Excel Forum!

Now, I am on a new question. I have to create a user form, its must be an excel embedded user input dialog, that takes variable inputs and then carries out actions as defind in the macro code.

I have not even a little idea of where to begin with. Basically, when the user gives the input in the user form, the macro must look for the ranges matching input value and then copy a chart and some data into a sheet in the same workbook where the user form is located.

Again, there are two variables, the user input for range matching and then a particular file string, there are two strings 12h30 and 19h.

For example:

1st user input is 12h30 (for file string)
2nd user input is France (to look for france in all ranges in all worksheets and workbooks). The data to be copied is always present relatively in same position for all serarch ranges that would match.

Any help will make my problem easier.

Thanks,
Sanjeev