LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jim
 
Posts: n/a
Default spinner linked cell problem

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In Cell Validation List & Linked Cell VLOOKUP BEEZ Excel Discussion (Misc queries) 7 July 1st 07 07:17 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Can I control linked cell property value in a copied ActiveX contr Beechbeard Excel Discussion (Misc queries) 0 May 4th 05 10:30 PM
Problem with IF condition or vector lookup? J-Philippe Excel Worksheet Functions 4 January 15th 05 08:41 PM


All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"