How to create dialox boxes?

I am trying to create a daolg box /and or macro that will allow me to check
the information form a list that I have defined in Excel. This information
will be directly put into the cell.

Thanks for your help

Checking a list is a little vague. What do you mean by Check?

--
Regards,
Tom Ogilvy

"MIKE" <[email protected]> wrote in message
news:[email protected]...
> I am trying to create a daolg box /and or macro that will allow me to
check
> the information form a list that I have defined in Excel. This information
> will be directly put into the cell.
>
> Thanks for your help
>
>

Mike,

If what you mean by check is compare or look for some common value then you
could try something like this:

For Each c In Range("E11", Range("E10").End(xlDown))
exspec = c.Value
Set y = Range("K1101", Range("K1100").End(xlDown)).Find(exspec,
LookIn:=xlValues)
If y Is Nothing Then
Your action here
End if

I used this to compare 2 lists and then take some appropriate action.

"MIKE" wrote:

> I am trying to create a daolg box /and or macro that will allow me to check
> the information form a list that I have defined in Excel. This information
> will be directly put into the cell.
>
> Thanks for your help
>
>