Search:

Bump...
I think is very complicate...

Hello,

I searched for a code to find all occurrences of a name (say Ron) of a particular drive (say D: \), but I found what I needed to do. The name can be anywhere in the root drive or folder or...

Mike, thank you very much.
Have a good day.

Hi,

Intro cell with data validation I want to have all the sheet names (except the first sheet), but dynamic. I mean if you add or delete a worksheet, I want to see this in cell with data...

Admin,

Thank you very much.

@Admin,

I managed to make the code to run automatically at each change of cell B7, B2 and D2.
Once again thank you.

Hello Admin,

Thank you. Excellent. Code is excellent. Thank you very much.
How can I modify the code to be executed on every change in cell B7, B2 and D2.

Hi,

My workbook has sheet "Main" and other sheets with names like Oct-2012, Nov-2012 ....Ian-2013... Dec-2020)

Sheet "Main" is a report, all other sheets are hidden.

In B7 you can choose...

Hi Prince,

Thank you very much. It's all I need.
Once again thank you.

Hi,

How can I write the message in cell A2


Code:
Msg = "You selected:" & vbNewLine
For I = LBound(FileNames) To UBound(FileNames)
Msg = Msg & FileNames(I) & vbNewLine
Next I

Hello Admin,

Thanks for the wishes. Also thanks for the code, it's perfect for me.
Thank you. I wish you an excellent day.

TomyLee

In my userForm i have 2 option button (one to create hyperlinks to all my sheets, and second to create buttons with link to all my sheets). A textBox where I can write name of new sheet where will be...

Hello Admin,

How can attach the workbook?

In my userForm i have 2 option button (one to create hyperlinks to all my sheets, and second to create buttons with link to all my sheets). A textBox...

Hello,

What code would I have to create buttons or links (depending on 2 option buttons in userform) for sheets in the file.
As an option want to write the name of new sheets in a...