How:spinbutton to display negative integers(e.g. range -10 to 10)

I have created a spinbutton and set min and max to -10 and 10 intending yield 
a range but clicking down from 0 gives me 65535.00.
 
0
Boris (51)
1/5/2006 10:07:04 PM
excel.misc 78881 articles. 5 followers. Follow

5 Replies
266 Views

Similar Articles

[PageSpeed] 24

That's because you can't set the linked cell property <0, you would need
code for this


-- 

Regards,

Peo Sjoblom

"Boris" <Boris@discussions.microsoft.com> wrote in message
news:978E6420-048D-449E-81E6-21E0BBB31409@microsoft.com...
> I have created a spinbutton and set min and max to -10 and 10 intending
yield
> a range but clicking down from 0 gives me 65535.00.
>


0
terre081 (3244)
1/5/2006 10:33:24 PM
Oops! here's the code, be in design mode and double click on the spinbutton
and use this

Private Sub SpinButton1_Change()
   Range("A2").Value = SpinButton1.Value
End Sub

(replace A2 with the cell where you want this)

remove the linked cell in the properties but keep max 10 and min -10


-- 

Regards,

Peo Sjoblom




"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:%23xGgIgkEGHA.272@TK2MSFTNGP10.phx.gbl...
> That's because you can't set the linked cell property <0, you would need
> code for this
>
>
> -- 
>
> Regards,
>
> Peo Sjoblom
>
> "Boris" <Boris@discussions.microsoft.com> wrote in message
> news:978E6420-048D-449E-81E6-21E0BBB31409@microsoft.com...
> > I have created a spinbutton and set min and max to -10 and 10 intending
> yield
> > a range but clicking down from 0 gives me 65535.00.
> >
>
>


0
terre081 (3244)
1/5/2006 10:38:20 PM
There is an alternative that does not require code. Just create a
cell link for the spin button that goes from 0 to 20 (assume that
cell is C1). Then create a link to that cell in cell B1 that says
=C1-10. You can hide one or both cells under the spinner button if
you wish.

Now just use cell B1 as cell that you want values to go from -10
to +10. You can do this type transformation for other purposes. 
If you need numbers to go from 1% to 20% just divide the link cell by 100.


Pieter Vandenberg

Peo Sjoblom <terre08@mvps.org> wrote:
: Oops! here's the code, be in design mode and double click on the spinbutton
: and use this

: Private Sub SpinButton1_Change()
:    Range("A2").Value = SpinButton1.Value
: End Sub

: (replace A2 with the cell where you want this)

: remove the linked cell in the properties but keep max 10 and min -10


: -- 

: Regards,

: Peo Sjoblom




: "Peo Sjoblom" <terre08@mvps.org> wrote in message
: news:%23xGgIgkEGHA.272@TK2MSFTNGP10.phx.gbl...
:> That's because you can't set the linked cell property <0, you would need
:> code for this
:>
:>
:> -- 
:>
:> Regards,
:>
:> Peo Sjoblom
:>
:> "Boris" <Boris@discussions.microsoft.com> wrote in message
:> news:978E6420-048D-449E-81E6-21E0BBB31409@microsoft.com...
:> > I have created a spinbutton and set min and max to -10 and 10 intending
:> yield
:> > a range but clicking down from 0 gives me 65535.00.
:> >
:>
:>


0
1/6/2006 3:22:17 AM
Thanks for your reply and your time.

"Peo Sjoblom" wrote:

> Oops! here's the code, be in design mode and double click on the spinbutton
> and use this
> 
> Private Sub SpinButton1_Change()
>    Range("A2").Value = SpinButton1.Value
> End Sub
> 
> (replace A2 with the cell where you want this)
> 
> remove the linked cell in the properties but keep max 10 and min -10
> 
> 
> -- 
> 
> Regards,
> 
> Peo Sjoblom
> 
> 
> 
> 
> "Peo Sjoblom" <terre08@mvps.org> wrote in message
> news:%23xGgIgkEGHA.272@TK2MSFTNGP10.phx.gbl...
> > That's because you can't set the linked cell property <0, you would need
> > code for this
> >
> >
> > -- 
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> > "Boris" <Boris@discussions.microsoft.com> wrote in message
> > news:978E6420-048D-449E-81E6-21E0BBB31409@microsoft.com...
> > > I have created a spinbutton and set min and max to -10 and 10 intending
> > yield
> > > a range but clicking down from 0 gives me 65535.00.
> > >
> >
> >
> 
> 
> 
0
Boris (51)
1/6/2006 7:18:04 PM
Thanks to both of you for the ideas.

"vandenberg p" wrote:

> There is an alternative that does not require code. Just create a
> cell link for the spin button that goes from 0 to 20 (assume that
> cell is C1). Then create a link to that cell in cell B1 that says
> =C1-10. You can hide one or both cells under the spinner button if
> you wish.
> 
> Now just use cell B1 as cell that you want values to go from -10
> to +10. You can do this type transformation for other purposes. 
> If you need numbers to go from 1% to 20% just divide the link cell by 100.
> 
> 
> Pieter Vandenberg
> 
> Peo Sjoblom <terre08@mvps.org> wrote:
> : Oops! here's the code, be in design mode and double click on the spinbutton
> : and use this
> 
> : Private Sub SpinButton1_Change()
> :    Range("A2").Value = SpinButton1.Value
> : End Sub
> 
> : (replace A2 with the cell where you want this)
> 
> : remove the linked cell in the properties but keep max 10 and min -10
> 
> 
> : -- 
> 
> : Regards,
> 
> : Peo Sjoblom
> 
> 
> 
> 
> : "Peo Sjoblom" <terre08@mvps.org> wrote in message
> : news:%23xGgIgkEGHA.272@TK2MSFTNGP10.phx.gbl...
> :> That's because you can't set the linked cell property <0, you would need
> :> code for this
> :>
> :>
> :> -- 
> :>
> :> Regards,
> :>
> :> Peo Sjoblom
> :>
> :> "Boris" <Boris@discussions.microsoft.com> wrote in message
> :> news:978E6420-048D-449E-81E6-21E0BBB31409@microsoft.com...
> :> > I have created a spinbutton and set min and max to -10 and 10 intending
> :> yield
> :> > a range but clicking down from 0 gives me 65535.00.
> :> >
> :>
> :>
> 
> 
> 
0
Boris (51)
1/6/2006 7:28:02 PM
Reply:

Similar Artilces:

Outgoing mail to show display name and not email address.
When users send mail, the recipents see the email address and not the display name. Is there a change I can make to show the users display name in the From field rather than the email address? We are using exchange 5.5 and outlook 2000 in corporate/workgroup mode. Regards, Dave On the properties of your IMS, go to the Internet Mail tab, and click the Advanced Options button and you'll see an option to enable or disable the sending of Display Names to the Internet. -- Neil Hobson Exchange MVP For Exchange news, links and tips, check: http://www.msexchangeblog.com "David Uns...

Do not display Zero values
Hi All I have two columns, in the first i have numbers, next labels. I need to make a pie chart that ignores all numbers (and respective labels) that are zero. Is there a way to do that? Thanks in advance! Stan Hi Stan, Check the example and the Alternative link example. http://www.andypope.info/charts/piezeros.htm Cheers Andy Stan Altshuller wrote: > Hi All > > I have two columns, in the first i have numbers, next labels. > I need to make a pie chart that ignores all numbers (and respective labels) > that are zero. > > Is there a way to do that? > > Tha...

formula to display cell address
I need a formula to display a cell address I want C1 to compare B1 to A1:A14 and bring back the cell reference if there is a match. In the below example C1 should read A2. Thanks in advance for any help. A B C 1 5 10 2 10 20 3 15 30 4 20 40 5 25 50 6 30 60 7 35 70 8 40 80 9 45 90 10 50 100 11 55 110 12 60 120 13 65 130 14 70 140 PiBJIHdhbnQgQzEgdG8gY29tcGFyZSBCMSB0byBBMTpBMTQgYW5kIGJyaW5nIGJhY2sgdGhlIGNl bGwgcmVmZXJlbmNlIGlmIHRoZXJlCj4gaXMgYSBtYXRjaC4KPiBJbiB0aGUgYmVsb3cgZXhhbXBs ZSBDMSBzaG91bGQgcmVhZCBBMi4KPiBUaGFua3MgaW4gYWR2YW5jZSBmb3IgYW55IGhlbH...

HTML DISPLAY
I AM TRYING TO DISPLAY A CUSTOMERS ACOUNT RECEIVABLE HISTORY AGING REPORT IN THE HTML SCREEN BUT HAVE NO IDEA HOW? ...

n/g for Windows 7 - my search doesnt find one
n/g for Windows 7 - my search doesnt find one apart from one French - is there an English out there that I missed!? Charlie+ Pick one or two: http://groups.google.com/group/microsoft.public.windowsxp.general/search?group=microsoft.public.windowsxp.general&q=win7+OR+%22windows+7%22+%2B+newsgroup Charlie+ wrote: > n/g for Windows 7 - my search doesnt find one apart from one French - is > there an English out there that I missed!? Charlie+ On 12/05/2010 08:48, Charlie+ wrote: > n/g for Windows 7 - my search doesnt find one apart from one French - is > there an Eng...

Spinbutton
I would like to use a spinbutton on a userform. I can get the button to work well going one way but can not seem to get it to go the other way. Ex I would like to button to produce an acending number while clicking on one side of the spinner and decending while clciking the other side My code now reads as follow: spinbutton1.value=spinbutton1.value+1 and that add a one to the spinbutton when I press on EITHER side of the button. Thanks Look at the two drop downs at the top of the userform module. The right drop down displays the "Events" associated with what is selected in the...

i can't send or recieve e mail
I keep getting the error code 0x800cccf6 please help shane wood <shane wood@discussions.microsoft.com> wrote: > I keep getting the error code 0x800cccf6 please help You first: what version of Outlook and what type of account? -- Brian Tillman Is this for a Hotmail or MSN account? If so, then read the following taken from: http://help.msn.com/resources/targeted/en-US/HotmailPIMv10/content/pim_trou_nofreedav.htm Can't access my free account from Microsoft Outlook or Outlook Express To protect our users from the increasing amount of unsolicited junk e-mail or spam sent fro...

Maximum characters that can be displayed in a cell
When I try to display a text having nearly 4200 characetrs, It is not appearing completely in a single cell. The complete text is appearing in the formula bar. I tried by increasing the cell width, height, and reducing font size etc. Is this a limitation with excel? Can anyone suggest an tip, so that entire text can be displayed in the cell? If the display is not possible, is there any way to print the entire text? Thanks in Advance for the help, Sandeep. Per XL's specifications (Help, "Specifications"), a cell can contain 32767 characters, but display and print only 102...

Spam with Exchange junk e-mail setting doesnt goto the "junk e-mail" folder in all cases/people.. 2007/2003 outlook
I have setup the spam filtering to send messages to the junk e-mail folder.. but it seems some users spam doesnt goto their junk e-mail folder, but their inboxes.. while others do indeed goto the junk email folder.. This isnt limitted to one type of client.. it seems to be both 2003 and 2007 outlook.. (we are using this setup option with gfi mail essentials for exchange.. set it to send spam to the junk email folder) I also checked the junk email setting in outlook (this case 2007).. its set to "low" and enabled.. greyed out, as I have the GPO enforced, but they still goto the in...

how to display shortcut keys for icons on toolbars
how to display short cut keys for icons on toolbars In xl2002: Tools|customize|Options tab|check "show screentips on toolbars" praveen wrote: > > how to display short cut keys for icons on toolbars -- Dave Peterson Dave In my installation of 2002 that only shows a descriptive name of the item. Nowhere can I find a way to show the shortcut keystrokes for that item. Like CTRL + B for Bold Gord On Thu, 27 Jan 2005 18:00:01 -0600, Dave Peterson <ec35720@netscapeXSPAM.com> wrote: >In xl2002: > >Tools|customize|Options tab|check "show screentips o...

print range from different sheets
is it possible to set a print range on sheets5 that contains various smaller ranges on sheets1, sheets2, sheets3, and sheets4? i know i could cut (or copy) and paste these ranges into sheets5 or maybe use powerpoint, but i would rather not. thanks, mike allen Hi maybe the following helps: http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Frank Kabel Frankfurt, Germany "mike allen" <mikeallen77@charter.net> schrieb im Newsbeitrag news:#z3Xt6mzEHA.3656@TK2MSFTNGP09.phx.gbl... > is it possible to set a print range on sheets5 that contains various smaller &g...

Entering a value in a field and displaying converted value in anot
Hi. I am designing a front end form for entering geological well data. I have to enter depth measurements, but the information we acquire can be in feet or metres. Although it is not difficult to manually calculate the conversions, I would like to enter the measurents into one of the fields and for the other field to be automatically filled with the converted value. So if I enter a depth of 300 into the depth in feet field, the depth in metres field will take the value of 300, multiply it by 0.3048 and display the value of 91.44. Likewise, if I enter a value in the metres field, the co...

Display Senders Detail
In my company we all have LTE's ( Lifetime Email Accounts ) My question is? When I look at the FROM box on my outlook - We wish to see the SMTP displayed as well. It this possible? OR - How can we display the Received line on the MESSAGE header - Viewed in the OPTIONS tab? We have one email account for our Office yet thousands of INTERNAL customers and would like to VIEW greater detail so we know who will handel the email without having to read it or have them put something special in the message ( subject) line! Can you show an example of what you would like to see. Does every...

Excel Chart Display Order
I typically have multiple charts stacked within a worksheet for quick comparison purposes; in Excel 2003 I simply clicked on part of the stacked chart I wanted to view, and this chart was displayed in its entirety. In Excel 2007, viewing a particular chart within a stack requires that I right-click, and then select "Bring to Front." Simply clicking the chart I want to view does not display it. Is there a less-time consuming way to do this, or am I just a cranky old man saying, "back in my day...." A lot of us were cranky about that one. Makes no sense. You could te...

Publisher no longer displays transparent gradients correctly.
I have been working faithfully w/Pub 2003 now for a few years; I use the program predominantly for superimposing MS drawing objects and text over imported jpgs and other photo/graphic formats, which I then export with Save as Picture. As such, I have a "template" file where I keep several designs I have created and use regularly. All of these consist of a basic MS drawing object shape grouped with Word Art. The fill (for both) consists of a gradient with separate transparency settings for each color. I have never experienced *any* problems whatsoever with Publisher until r...

Can't receive e-mail
Hi there We are using Windows Mail to read e-mail, but have now got a problem. When we attempt to read e-mail we get the following error message: - An unknown error has occurred. Account: 'pop3.blueyonder.co.uk', Server: 'pop3.blueyonder.co.uk', Protocol: POP3, Port: 110, Secure(SSL): No, Error Number: 0x80004005 We've re-set the Windows Mail settings, but still get this message. Can anyone help? Graham PS - We can send e-mail!!!!! The 0x80004005 error often indicates corruption of the mailbox on the server. In your browser go to https://webmai...

How to automatically track sent e-mail in 4.0?
I'm using the CRM - Outlook client on CRM 4.0 with all server and client rollup updates applied. Please tell me how to automatically track all email sent to, or received from, an email address that exists in the CRM. 1. I don't want to track ALL email. 2. I don't want to ONLY track e-mail sent in response to CRM email. 3. I don't want to ONLY track email from CRM Leads, Contacts, and Accounts. I don't want to use Option #3 and be required to click "Track in CRM" for every email I send from Outlook. Surely there must be a way to automatically track all ...

Activities not displaying in Calendar
I've used the proxy class to schedule all my appointment activities, but although they show up on my Activities tab, they do not display on the calendar. Also, they are marked as all day events, and I can see that they are inserted correctly into the Activity view in the db, but I am able to schedule many all day activities on the same day instead of getting the error I get when I'm scheduling from CRM. ...

Exchange message tracking
Is there a more verbose message tracking in Exchange? I can see the path a message takes from mailbox to mailbox. But what if a user deletes, permanently deletes (shift-delete) or moves a message and claims that it's lost. Is there a way I can track the movement of a message within a mailbox from folder to folder or from the inbox to permanent deletion (either intentionally - or via mailbox management?). Thanks. Not within Exchange. Nue "angry_white_male" <lesterwils@gmail.com> wrote in message news:1151504573.516606.30090@y41g2000cwy.googlegroups.com... > Is the...

displaying a chart in a form
How do I display an excel chart in a form? cd, Add an image control to the form. Copy the chart. Paste directly (Ctrl + V) into the "Picture" property of the image in the properties window. Adjust the "Picture Alignment", "PictureSizeMode" properties to suit. Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "cd" <deycd@hotmail.com> wrote in message news:1135274950.930389.39040@g43g2000cwa.googlegroups.com How do I display an excel chart in a form? I should have said I need the chart to refresh when the data ref...

how do I name ranges of data in Excel to export to Outlook?
I am trying to import a contact list from excel to outlook. When I try to do it, I get a message that says my spreadsheet has no named ranges, and that I need to name the range of data that I want to import. How do I go about doing this? Thanks! I assume it means you need to put headers on the top of your ranges Regards, Peo Sjoblom "Liz Rava" wrote: > I am trying to import a contact list from excel to outlook. When I try to do > it, I get a message that says my spreadsheet has no named ranges, and that I > need to name the range of data that I want to import. ...

Opportunity needs to display Account and Contact
We are using opportunities to track our forecasted sales. There are multiple contacts with an account, so Opportunities are linked to the contact person. However, when viewed from a list of all opportunities, it just diplays the Contact Name - not the underlying acount the contact is associated with. We need to have the company name on the account also displayed. Any ideas how to do that? I thought about mapping accountid on the contact records to the opportunity and then displaying that field...but it is a system field with a data type that cannot be added (Lookup). Any other ideas, abs...

Display MMC Error Message
While using Diskeeper, I got the error message: "MMC has detected an error in a snap-in. It is recommended that you shut down and restart MMC." It gave me 3 options and I chose Continue running and always ignore errors with this snap-in, regardless of user or session. However, I would like to be able to see this message again because I plan to do more troubleshooting and I want to see if it works. How do I reverse my action--is there a place in the MMC I would go or is there a registry key I need to edit? I'm running Windows XP SP3. -- DaffyD� ( : []= If I k...

Count Vaules in a range that appear in another range
I have three ranges e.g. Range 1 Range 2 Range 3 Bread Apples Bread Apples Oranges Buns Oranges Pears Buns Bread Pears Apples I'm trying to construct a formula that counts the number of times, say, and entry in Range 3 appears in Range 1 - In this instance the answer would be 3. Hi, try =SUMPRODUCT(($A$2:$A$100=c2)+($A$2:$A$100=c3)) Being a2 to a100 range 1 and c2 and c3 products in range 3 "T Newbery" wrote: > I have three ranges e.g. > > Range 1 Range 2 Range 3 > Bread Appl...

Display Data Table in chart but don't show plot area
I am using Excel 2003. I have created some charts/graphs with data tables, chart titles, etc. My customer only wants to see the data table and chart title for each graph. Is there a way to turn off the plot area and change the size of the chart so that the chart title is close to the data table? But the data table merely reflects what is in the cells used to make the chart! Why not just display that data in a new format? Or am I missing something? best wished -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "RW" <RW@discussi...