Message box with multiple cells

Hello,

Is there a way to set up a message box that will ask for the date in three different "cells" in the same message box?

For instance, Month__ Day__ Year__ where each __ represents a different "cell" within the same message box?

I need this to find a few different files that are all named by date but the dates happen to be in different formats.

Thanks!!

Shannon

I'm not exactly sure what you are asking, but I think to do what you need, you will have to build a userform. In your VB editor, click insert, then userform. Add three textboxes and labels for them, and a command button. Then, you can use those texboxes in your code.

I am not terribly familiar with userforms, but I will do some research and give it a shot.

Thanks!

Shannon

they seem complicated at first, but they are simple in nature. When you create the extboxes in the userform, any input in the boxes will be captured and available for use in your macro. Usually, they are called Textbox1, Textbox2, etc. and you can assign the macro to run on the OK button or such. So after the user inputs those values, you can reference those in the macro that runs on OK. Here is a link I found useful when learning Userforms: http://www.excel-vba-easy.com/vba-us...excel-vba.html

Interesting. Thanks!

Shannon