View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Where did my question go?

Hi Tendresse (I hope you see this)

There are problems with the web newsgroup interface
Use Outlook Express or Windows Mail to connect to the newsgroups

Use this server when you add a news account
msnews.microsoft.com

This was my answer


Hi Tendresse

You can check a cell value in the workbook and if it is not "no" for example
show the msgbox

Private Sub Workbook_Open()
If Sheets("Sheet1").Range("A1").Value < "no" Then
MsgBox "Hi"
End If
End Sub

You can also build a small userform with a tickbox to fill the cell value with this value


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tendresse" wrote in message ...
I just posted a question less than an hour ago (title: Do not show this
message again). I could see it listed for a while then it disappeared! I have
been notified by email that i received a response, however i cannot see it.
Every time i refresh the screen i don't get the question or the answer? where
did they go????
Tendresse