Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
Is there any way to make a cell containing link to change color on mouse
over? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
Hi
this would be very difficult (maybe using aPI calls9. Problem is there's no mouse_over event on worksheet level -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Is there any way to make a cell containing link to change color on mouse over? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
Thanks Frank. But what is PI calls9. I'm a newbee.
"Frank Kabel" wrote in message ... Hi this would be very difficult (maybe using aPI calls9. Problem is there's no mouse_over event on worksheet level -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Is there any way to make a cell containing link to change color on mouse over? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
Sorry
should read API calls (Application Programming Interface). That is you probably have to access directly the Windows API function calls, get the mouse position from them and then (probably relatively complex) calculate the cell position under the mouse cursor (taking screen resultion, zoom factor, etc. into account9 So IMHO not something i would do. Maybe you can explain WHY you're trying to do this. -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Thanks Frank. But what is PI calls9. I'm a newbee. "Frank Kabel" wrote in message ... Hi this would be very difficult (maybe using aPI calls9. Problem is there's no mouse_over event on worksheet level -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Is there any way to make a cell containing link to change color on mouse over? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
Well, it's not really important but this worksheet is going to have links to
many other pages in a workbook. So I thought it would be nice to make them work like a hoover button on a web page.Seems like I have to give it up. Many Thanks. Igor Sudnik. "Frank Kabel" wrote in message ... Sorry should read API calls (Application Programming Interface). That is you probably have to access directly the Windows API function calls, get the mouse position from them and then (probably relatively complex) calculate the cell position under the mouse cursor (taking screen resultion, zoom factor, etc. into account9 So IMHO not something i would do. Maybe you can explain WHY you're trying to do this. -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Thanks Frank. But what is PI calls9. I'm a newbee. "Frank Kabel" wrote in message ... Hi this would be very difficult (maybe using aPI calls9. Problem is there's no mouse_over event on worksheet level -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Is there any way to make a cell containing link to change color on mouse over? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
Hi
why not insert a hyperlink (Insert - Hyperlink) -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Well, it's not really important but this worksheet is going to have links to many other pages in a workbook. So I thought it would be nice to make them work like a hoover button on a web page.Seems like I have to give it up. Many Thanks. Igor Sudnik. "Frank Kabel" wrote in message ... Sorry should read API calls (Application Programming Interface). That is you probably have to access directly the Windows API function calls, get the mouse position from them and then (probably relatively complex) calculate the cell position under the mouse cursor (taking screen resultion, zoom factor, etc. into account9 So IMHO not something i would do. Maybe you can explain WHY you're trying to do this. -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Thanks Frank. But what is PI calls9. I'm a newbee. "Frank Kabel" wrote in message ... Hi this would be very difficult (maybe using aPI calls9. Problem is there's no mouse_over event on worksheet level -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Is there any way to make a cell containing link to change color on mouse over? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
Yes, that's right but it's going to be a text hyperlink (or picture) and I
wanted the cell containing a text hyperlink to change color when mouse is over it. I think I want too much. "Frank Kabel" wrote in message ... Hi why not insert a hyperlink (Insert - Hyperlink) -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Well, it's not really important but this worksheet is going to have links to many other pages in a workbook. So I thought it would be nice to make them work like a hoover button on a web page.Seems like I have to give it up. Many Thanks. Igor Sudnik. "Frank Kabel" wrote in message ... Sorry should read API calls (Application Programming Interface). That is you probably have to access directly the Windows API function calls, get the mouse position from them and then (probably relatively complex) calculate the cell position under the mouse cursor (taking screen resultion, zoom factor, etc. into account9 So IMHO not something i would do. Maybe you can explain WHY you're trying to do this. -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Thanks Frank. But what is PI calls9. I'm a newbee. "Frank Kabel" wrote in message ... Hi this would be very difficult (maybe using aPI calls9. Problem is there's no mouse_over event on worksheet level -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Is there any way to make a cell containing link to change color on mouse over? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
Hi Igor,
On a web page, I'm more familiar with the tooltip (title=) as seen at the top of my search.htm webpage than with "cheap effects". In Excel the tool tip is called a Screen Tip and you can override the link that would normally be shown by choosing ScreenTip in the upper right corner of the Edit Hyperlink dialog (Ctrl+K). Not available form the HYPERLINK Worksheet Function. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Igor Sudnik" wrote in message ... Well, it's not really important but this worksheet is going to have links to many other pages in a workbook. So I thought it would be nice to make them work like a hoover button on a web page.Seems like I have to give it up. Many Thanks. Igor Sudnik. "Frank Kabel" wrote in message ... Sorry should read API calls (Application Programming Interface). That is you probably have to access directly the Windows API function calls, get the mouse position from them and then (probably relatively complex) calculate the cell position under the mouse cursor (taking screen resultion, zoom factor, etc. into account9 So IMHO not something i would do. Maybe you can explain WHY you're trying to do this. -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Thanks Frank. But what is PI calls9. I'm a newbee. "Frank Kabel" wrote in message ... Hi this would be very difficult (maybe using aPI calls9. Problem is there's no mouse_over event on worksheet level -- Regards Frank Kabel Frankfurt, Germany "Igor Sudnik" schrieb im Newsbeitrag ... Is there any way to make a cell containing link to change color on mouse over? |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
sorry didn't notice the two additional postings. Unfortunately
the screen tip, I think, is only available from a hyperlink. You can get a similar effect from a validation, but you have to actually click on the cell for edit. |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
You might see if floatwnd.zip would work for you
looks like it would be a lot of bother but it is an API call. http://www.bmsltd.ie/Excel/Default.htm |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
Thank you for your help guys.
"David McRitchie" wrote in message ... You might see if floatwnd.zip would work for you looks like it would be a lot of bother but it is an API call. http://www.bmsltd.ie/Excel/Default.htm |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color change on mouse over
Hi Igor, it may not be exactly what you want, but it may be of
some use... (in the workbook....) Option Explicit Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range) Static OldCell As Range If Not OldCell Is Nothing Then OldCell.Interior.ColorIndex = xlColorIndexNone End If Target.Interior.ColorIndex = 6 Set OldCell = Target End Sub Hope it helps.. seeya ste |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
Mouse pointer (arrow) change color? | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Can I change the font/shading of a cell by moving the mouse over i | Excel Worksheet Functions |