Macro message / Dismiss clipboard message

ChrisY

New Member
Joined
Feb 27, 2002
Messages
7
I a workbook with VBA code that opens and checks the value of a cell in another worksheet located on a server. The idea is that, if I change the cell value on the server worksheet, I can compare the value to the opening worksheet and copy the new data to the opening worksheet if it has changed. All works well with that; however, I would like to give the user a message "Checking for Updates" that stays open while the VBA code is running - maybe with a progress bar(?). Is this possible?

Also, when a update is performed, I get a message to the effect that "You have placed a large amount of information on the Clipboard. Do you want the information to be available...? I want to dismiss the message with a "No" response automatically. Any way to do this?

Thanks for your help.

ChrisY
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
On 2002-02-28 08:43, ChrisY wrote:
I a workbook with VBA code that opens and checks the value of a cell in another worksheet located on a server. The idea is that, if I change the cell value on the server worksheet, I can compare the value to the opening worksheet and copy the new data to the opening worksheet if it has changed. All works well with that; however, I would like to give the user a message "Checking for Updates" that stays open while the VBA code is running - maybe with a progress bar(?). Is this possible?

Also, when a update is performed, I get a message to the effect that "You have placed a large amount of information on the Clipboard. Do you want the information to be available...? I want to dismiss the message with a "No" response automatically. Any way to do this?

Thanks for your help.

ChrisY

Chris,

You can add a message to the Status bar at the bottom of the screen:

Application.StatusBar = "your message"
at the end of your code, remember to set this back to
Application.StatusBar = False

The following code will stop the other message appearing - but I don't know if it assumes a yes or a no!
Application.DisplayAlerts = False
(again, this needs to be set to true at the end of your code).

Doug
 
Upvote 0
Douglas,

Thanks! That worked on the first part. I found a workaround for the clipboard problem - apparently it only happens when you copy over 100 cells. The fix is to tell Excel to copy "a" cell prior to closing, then the notice is not produced.

CY
This message was edited by ChrisY on 2002-02-28 11:17
 
Upvote 0
On 2002-02-28 11:15, ChrisY wrote:
Douglas,

Thanks! That worked on the first part. I found a workaround for the clipboard problem - apparently it only happens when you copy over 100 cells. The fix is to tell Excel to copy "a" cell prior to closing, then the notice is not produced.

CY
This message was edited by ChrisY on 2002-02-28 11:17

Thats one way other wise just clear the clipboard via
Application.CutCopymode = false

at the end of any copy/pates routine.

Ivan
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,952
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top