Results 1 to 2 of 2

Thread: Combobox in Excel

  1. Oct 1st, 2003, 07:33 PM #1
    fkheng
    fkheng is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2002
    Posts
    332

    Combobox in Excel

    I am using Microsoft Excel 2000. Although this is a VBA section, I just would like to know if it is possible, without the intervention of VBA, to have a combobox within a cell in an Excel sheet, so that the user can choose a pre-defined selection from a combobox list. Is this possible? (I am not referring to the "Right-click" & "choose Pick From List" as this gives a whole list of previously inserted information.)
    Reply With Quote Reply With Quote
  2. Oct 5th, 2003, 12:44 AM #2
    WorkHorse
    WorkHorse is offline
    Fanatic Member WorkHorse's Avatar
    Join Date
    Jul 2002
    Location
    Where you live.
    Posts
    591
    Use data validation. In Excel, select the cell that you want to have the drop-down. Go to Data, then Validation. Under Settings, set the Allow field to List. Then, under Source, selet a range of cells to use in the drop down list, or type a comma-delimited list of values. Click OK.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width