Computing.Net > Forums > Windows XP > Data validation code(excel)

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Data validation code(excel)

Reply to Message Icon

Name: angcobo
Date: February 22, 2006 at 02:45:48 Pacific
OS: WinXP
CPU/Ram: enough
Product: Teramars
Comment:

plz assist me with the code for excel combobox-data validation code.i'm new in the programming bussiness so if u could just simplfy for me.please help....



Sponsored Link
Ads by Google

Response Number 1
Name: lukeles
Date: February 22, 2006 at 02:55:00 Pacific
Reply:

What is the excel combobox-data validation code??


0

Response Number 2
Name: angcobo
Date: February 22, 2006 at 03:30:34 Pacific
Reply:

I take it you skipped the "subject" line....
it is the data-validation-code for a combo box using excel


0

Response Number 3
Name: JOe
Date: February 22, 2006 at 04:55:50 Pacific
Reply:


1.To create a combo box in Excel, the first thing that you need to do is display the Forms toolbar. To do this, under the View menu, select Toolbars > Forms.

2.The Forms toolbar should now appear. Select the combo box icon. Then left-click on the spreadsheet where you'd like the combo box object to appear and drag the mouse pointer to the right until the combo box is the desired size.

3.Next, you will need to enter somewhere on your spreadsheet, the values that you'd like to appear as selections in the combo box.

4.Next, right-click on the combo box and select Format Control from the popup menu.

5.When the Format Object window appears, select the Control tab. Then select the input range for the combo box. This is the cells that contain the values that you wish to see in the combo box.

6.Then select the Cell link. This the cell that is linked to the combo box. This cell will display the combo box selection.

7.Click on the OK button.

Now when you return to the spreadsheet, your combo box should display a selection of values.

When you select a value, the linked cell should display the index of the selection.

The INDEX formula would return the value selected.


Hope it helps.

Please help!! I have a Computer running Win98 SE and when I power it up I get as far as the desktop and then I get a error message that says " Explorer: this program has performed an illegal operation


0

Response Number 4
Name: Badboy
Date: February 22, 2006 at 07:53:26 Pacific
Reply:

I'm curious, are you really in the "programming bussiness"?


0

Response Number 5
Name: angcobo
Date: February 23, 2006 at 22:46:59 Pacific
Reply:

Thank you Joe...
As for the badboy,Im a construction project manager,i have to create something which incl codes and the whatnots,and yes,incl programming.I am new in the programming bussiness coz i dont deal with it........
I'm curious,didn't yuo have a better,constructive response????????
Elevate atleast into the badMAN level.......


0

Related Posts

See More



Response Number 6
Name: angcobo
Date: February 24, 2006 at 01:31:58 Pacific
Reply:

Thanx a bunch jOe,
Now instead of returning the auto values,i want it to return the values that i will set as their constants,eg when i click on "Human body temp" i want it to return "36.5" and so on for other entries.....


0

Sponsored Link
Ads by Google
Reply to Message Icon






Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows XP Forum Home


Sponsored links

Ads by Google


Results for: Data validation code(excel)

True Image 8 not valid archive! www.computing.net/answers/windows-xp/true-image-8-not-valid-archive/150118.html

EXCEL drop down lost www.computing.net/answers/windows-xp/excel-drop-down-lost/180413.html

xp download in april? www.computing.net/answers/windows-xp/xp-download-in-april/131953.html