Conditional Formatting doesn't refresh after Macro
Hello,
at first, sorry about my bad englisch...
I write Figures via VBA in cells containing a conditional formatting. Problem here: Formatting doesn't refresh. Only if I set the cursor into the cell and put the enter-key, the cell refreshes the format.
When I simulate this action with vba - the cell-format also doesn't refresh.
Anybody an idea?
Thommy
Just a blind shot..
In vba code.. just before END SUB, try by adding a line.. Calculate
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
hey Debraj Roy,Originally Posted by Debraj Roy
Just a blind shot..
In vba code.. just before END SUB, try by adding a line.. Calculate
Unfortunately it doesn't work. Sorry I forgot something:
- I work with Excel 2003
- I reference Excel-Objects within Access-VBA
Here is my code:
Please Login or Register to view this content.
one more blind shot..
Please Login or Register to view this content.
no effect
Finally .. sample required..
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
I found the cause: I write figures as text in cells... (forgot a cast)
nevertheless - thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks