Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 4th, 2008, 06:46 PM
Authorized User
 
Join Date: Jun 2008
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to mona_upm84
Default Avoid enter data from keyboard into combobox

Hi all again,

I need more help please....
What coding can i use to avoid a user entering data manually into the combobox? I want them to select only from the list given. Thanks...


Regards,
Mona

 
Old September 5th, 2008, 01:26 AM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Hi Mona

You can try setting the style of the Combobox to List in the properties window

or you can set through code in Userform_Intialize/Load

 ComboBox1.Style = fmStyleDropDownList


Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Avoid postback when a ComboBox is clicked Kika Other Programming Languages 0 January 21st, 2008 03:08 PM
How to disable ALT+ENTER keyboard shortcut q2q2 BOOK: Access 2003 VBA Programmer's Reference 0 November 8th, 2006 05:05 PM
Entering a password, then "enter" from keyboard? natalie09 Javascript How-To 2 April 22nd, 2004 02:56 PM
posting a textarea with a keyboard enter md0004 Javascript How-To 4 March 12th, 2004 06:01 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.