Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Below is the text from concierge chat, unfortunatly this seems to have not
given us the answers we are looking for. {James Hawkins} I have an enduser who is having problems in excel that are way beyound my scope of experience. {James Hawkins} Problem as described by the user: {James Hawkins} Excel 2003 I add a spinner control to the work sheet Link it to a cell SmallChange property is set to 1 Max property is set to 100 Min property is set to -100 When I spin down from 0 to -1, the Value property shows -1 but the linked cell changes from 0 to 65535. It should change to -1. Changing the cell format has no effect. How can I fix this? Second problem: I add a control to a sheet. Unless I use a 1 in the Placement property, versus 2 or 3, when I print the page or preview, all my controls move to the left most side of the sheet. Why can I not use placement options 2 or 3? {Myke} http://groups-beta.google.com/group/...24e5eea15d609f {James Hawkins} That looks like what he is talking about, I will forward the link to the user. {Myke} I was not able to locate any specific information relating to your second issue James. {Myke} Are you a TechNet Plus subscriber? {James Hawkins} User reply to link: Yes, This is it. I have already used these workarounds. It is a major pain because I have so many spin buttons. Linked cells are much easier to updated than VB code when moving items around the sheet. {James Hawkins} From the user: The VB code option offered by John Green does not work. The value is the cell does not move from 0 either way. Back to square one. any help would be appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Can I control linked cell property value in a copied ActiveX contr | Excel Discussion (Misc queries) | |||
Problem with IF condition or vector lookup? | Excel Worksheet Functions |