Posts7Registration dateMonday March 18, 2019StatusMemberLast seenSeptember 20, 2019
Updated on Sep 19, 2019 at 05:04 PM
Blocked Profile -
Sep 20, 2019 at 07:21 AM
Re: "Microsoft Excel for Mac version 16.16.14 (190909)"
(aka "Excel for Mac 2016")
Q: referring to the cell the cursor is currently in,
how can I make the entire cell blink?
And can I add color?
And is it possible that if a cell is a result of a formula
to have it blink, in a color, if a certain value is reached?
Like under or over a certain number or other value?
Model Name: Mac mini
Model Identifier: Macmini8,1
Processor Name: Intel Core i7
Processor Speed: 3.2 GHz
Number of Processors: 1
Total Number of Cores: 6
L2 Cache (per Core): 256 KB
L3 Cache: 12 MB
Hyper-Threading Technology: Enabled
Memory: 64 GB
Boot ROM Version: 220.218.104.22.168 (iBridge: 16.16.6571.0.0,0)
Sub insertBlinker () With activesheet.pictures.insert ("e:\youblinker.gif") With .shaperange .lockaspectratio = msotrue .width=15 .height = 15 End with .left = activesheet.cells (row, column) .top = activesheet.cells (row, column) .placement = 1 .printobject = true End with End sub
Ok. So if you want this on sheet5, in the object explorer, click on sheet5. You ahould have a blank white work space. Paste the above function into that sheet in visual basic. Now, cut the below code and paste it on the same workspace as the last paste.
Private sub worksheet_selectionChange (byval Target as range)
Nret = insertpic (target.column, target.row)
Well the gif wont animate unless you put it into a web browser object. So the blinking gif wont work, even though the code does highlight the activecell with an image.
I did write code that does make the activecell blink, but In order to make the highlighted cell go back to white, I have to clear all cells in the sheet, and I dont want to wreck your current formatting.