Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    customize combo boxes (2000)

    I am wondering if any one has experience seeting combo boxes properties?

    I am having a issue with shifting from entering data into a cell and moving to click a option from the combo box it seems that when i double click on a cell i get the blinking cursor and after i type or type nothing and click on my combobox I cannot activate the combo box unless i click somewhere on the outside off to the side of the activated cell and then on the combo box. is there an option to allow the switching?

  2. #2
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: customize combo boxes (2000)

    one method i fould is going to tools option and the editing tab and click off the edit directly in cell

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: customize combo boxes (2000)

    Do you really want to pay that price?

  4. #4
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: customize combo boxes (2000)

    well it works the same except you click on the cell you want to add something in and type getting no blinking cursor but it seems to work the same unless you know something that might be troublsome to me later on??

    I did notice that a combo box is not good for numbers if you want to use them in a formula somewhere else <img src=/S/overclocking.gif border=0 alt=overclocking width=99 height=47>

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: customize combo boxes (2000)

    You can still click in the formula bar to edit a cell's contents. If you will be the only user of the workbook, it's not a problem. But if others will use it too, you can't really expect all of them to turn of direct cell editing.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: customize combo boxes (2000)

    This occurs when you use a combo box from the Control Toolbox and as far as I know, there's nothing you can do about it.
    If you use a combo box from the Forms toolbar, you can go directly from editing a cell to selecting an item in the combo box.

    (Note: an important difference between the two is that the linked cell displays the selected item (text) for a combo box from the Control Toolbox, and the index (1, 2, 3...) of the selected item for a combo box from the Forms toolbar)

  7. #7
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: customize combo boxes (2000)

    yes i guess iwill jest leave it then until i get time to change all the combo form boxes to the the proper one
    <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22> it will be annoying to explain to every one how to edit stuff.
    thanks Hans!

  8. #8
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: customize combo boxes (2000)

    > combo box is not good for numbers

    You just have to use the INDEX function to get the numbers. On the other hand, Data Validation always seems a better choice to me than either combobox. You can have your cake and eat it too! <img src=/S/burga.gif border=0 alt=burga width=40 height=15>
    See attached spreadsheet which compares the three methods. HTH --Sam.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: customize combo boxes (2000)

    Personally, I avoid datavalidation, since it is to easy for users to "get around it" even accidentally (it can be bypassed and "lost" simply by copying another cell over it).

    I find the forms toolbar the easiest to use for most purposes. It also has the added advantage as being the only ones that can be added to a chart object, which is what the primary use I have for them is.

    I find myself only usinig the control toolbox items when I really need the formatting, or want a little more "control" over how they work (since they have more events to be triggered).

    As a general comment for other posters (I know you are aware of this): In general the ease of use and the "control" are opposites. The ease of use is DataValidation then forms then control toolbox. The control over the item is the opposite trend.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •