Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / December 2006

Tip: Looking for answers? Try searching our database.

If A>0, I need a message pop-up box to show text in B1

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mrlanier@hotmail.com - 31 Dec 2006 20:42 GMT
If Sheet1, A1>0, I want the contents of B1 to appear in the message
box.  The only button I need in the message box is OK.  Clicking on the
OK needs to do nothing more than to close the box.  Can anyone help
with this?  (I'm a novice at macros, so please be somewhat detailed.)
Thanks.

Michael
Tom Ogilvy - 31 Dec 2006 21:44 GMT
What will make the value in Sheet1, A1 change?  Manual edit, formula, DDE
link?  If it is a formula or DDE link do you want the box to pop up on every
calculate as long as it remains above zero?   If not, when do you want it
next to pop up?

Signature

regards,
Tom Ogilvy

> If Sheet1, A1>0, I want the contents of B1 to appear in the message
> box.  The only button I need in the message box is OK.  Clicking on the
[quoted text clipped - 3 lines]
>
> Michael
mrlanier@hotmail.com - 31 Dec 2006 22:00 GMT
Tom,

I have set A1 to return values under certain conditions.  For example,
if an erroneous entry of a certain nature has occured elsewhere, it
might return a value of 1 in A1.  If it is an error of a different
type, it might return 2, and so forth.  The type of error will appear
as text in B1, according to the corresponding value in A1.  If I have a
single OK button to show that the message has been recognized, I would
like for the message pop-up to remain open until the user clicks on the
OK button.  Can you help with this?  Again, I am a VB novice, so please
give enough detail.  Thanks.

Michael
mrlanier@hotmail.com - 31 Dec 2006 22:06 GMT
Tom,

There is perhaps a better way to approach my problem.  A one time
pop-up would be great, and without an OK button if I could make it
remain for approximately 10 seconds.  It would not need to repeat
itself.  The next message would pop-up only if there were to be a
change in the A1 value.

Also, assuming there would be an A1 type of construct in multiple
worksheets, would there need to be more than a single UserForm?

Thanks,

Michael
Tom Ogilvy - 31 Dec 2006 23:04 GMT
You didn't bother to answer the question on how A1 would change.  But it
sounds like it might be changed by a macro.  If so, use the same macro to
pop up the message box, i.e change the value of a1 and show the message box
in the same procedure. .

Signature

Regards,
Tom Ogilvy

> Tom,
>
[quoted text clipped - 10 lines]
>
> Michael
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.