Drop Down List
How do I create a Drop Down List? Not to be confused with ListBox or ComboBox....
I want the drop down list to contain four choices Site1, Site2, Site3 and Site4
is there a control ordo I have to write some code??
any ideas???
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
How To Drag Drop From List Box To Either Text Box Or List Box
hello everyone i need to know how to drag drop text from a listbox to another listbox.....
i was able to set it up for a list box to a text box but when i would add another name to it it would erase the previous one...
and really i need it to be a list box so that the user cant type in it...
at the same time i need to know if while you are dragging and droping the file is it possible to grey out the text in the box you are dragging it From.....thanks
Same List Box Drag && Drop And Re-order List
List Box Control Question (Not Listview control)
Can someone show me how to drag and drop a list item
from one position to another in the same list box and have the item list automatically reorder itself?
Thanx!
JC
nnpc@att.net
Drag N' Drop From List Box To List Box
I have an application that has eight list boxes that pointing to specific directories on eight different machines. The list boxes display the files that are currently on these eight directories and sometimes they need to be moved manually from one machine to another. Currently I have to use network neighborhood to drag n' drop, but I would like to implement this feature into my application so that my users can drag and drop from within the application.
I still consider myself a newbie with programming so detailed information would be appreciated.
Thank you in advance everyone.
-Nielubie (a.k.a. Pete)
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Conquering a difficult goal is a lot more rewarding then a simple goal.
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Edited by - Nielubie on 10/31/2004 2:56:44 PM
Drop Down A Drop Down List?
Is it possible to hit a command button and have a drop down list drop down so the user can see all the choices without clicking on it first?
Thanks,
Dan
Drop Down List
I'm trying to walk a user through a form. I would like to make them pick from a drop-down list. How do I get the Macro to go the the cell that contains the drop-down list, pause until the user picks the entry from the list and then continue to the next field with another drop-down list. Please help.
Thanks.
Drop Down List
I am trying to create a drop down list of hyperlinks in word or excel. I have no idea of how to accomplish this. Any help provided will be appreciated.
Drop Down List?
Hey, im trying to make a drop down for a web browser such as File, Edit, Help, etc. How would you do this?
Drop Down List Box
I'm working on an ASP.NET web application with a drop down list box (in a web user control), in which at runtime, a number is added (x+1), etc. for each element in an xml data list. Is there a way to then have a select case function for each item added to the drop down box?
thanks,
Eric
Drop Down List
How can the printer collection be displayed in a Drop Down List? Also, when a printer is selected how can it be set as the default printer in that program only without changing the default for all programs.
Drop Down List
hii.. hw can i build a form with two drop down lists( combo boxes type 0), one for students and the other for their study center code. when this form is loaded fill the lists from the arrays. if the user pulls down one of the list and clicks on a student the corresponding study center code is displayed in the text box of the other list?
thnx for rplyin..
Drop Down List Box
i would like a drop down list box or just a list box on my program that lists all the topics available to read about. What i want is once the user highlights a topic then hits a button it will load up a certain form. Is this possible??
Drop Down List
hello guys
i've create a drop down list with some items in it.I want to click on one of them and open a toolbox that has some buttons,icons,e.t.c. clicking on another item of that drop doun list i want to open diferrent toolboxes and so on.
Greetings from far far far away
VBA - Drop Down List
hi to all
I am trying in VBA. I am very poor to use VBA.
How do i get Dropdown List Box value when i click the Button.
i tried like
sheet1.shapes("combo1").name
But no use..
Please help me
Cheers
Drop Down List
I want to create my front screen just as Windows Explorer. Address bar is to be placed. From my point of view it is an Image combo but after writing something on the bar drop down list appears. If any body has tried it please give me your inputs as it is very important in my project.
Drop Down List
Is it possible to have a drop down list with pictures next to the text (like the colours menu attached).
It would be even better if there was just a plain list box with pictures next to text.
and is there also a way to get the picture blocks bigger?
Thanx in advance
-THe_SHadoW
IIS App And Drop Down List...Please Help...
I only have one problem... I want to have a page with 1 drop down list and a submit button... I am writing an IIS app and need to know how to tell which selection the user has selected. Any examples would be helpfull. Like, a drop down list with 2 entries and the code that captures the selection posting a simple message stating which was selected.
Thanks to all for any help. Do I need to use javascript or can I do it within the VB IIS app?
AmigaZoid
Drop Down List
How do I create a Drop Down List? Not to be confused with ListBox or ComboBox....
I want the drop down list to contain four choices Site1, Site2, Site3 and Site4
is there a control ordo I have to write some code??
any ideas???
Drop-down List In RTB
Using a RichTextBox component in a Form, I want to create a drop-down list to modify the letter's size. How can I do it?
Drop Down List
Hello everyone,
I have an easy one for you here. I am trying to make a drop down list with Sir Names in them, i.e, "Mr.", "Dr.", etc. I think that I need to use a drop down list box for this right? Because in a combo box the user can type in a new field and I would not want that. So my question is can I make a list box a drop down and how.
Thank you,
Chris
Drop Down List Box
I have a drop down list box connected to a access data base.
My question:
What is the code to let the user start to type something at the top of the list and will as they type search the list finding the nearest match with in the list. Any help is greatly appreciated.
How To Add To A Drop Down List
How Do I add another item(function) to a drop down menu list.
I have a Menu drop down called Reports
I want to add another item. I am very new to VB
thanks in advance.
Drop Down List Combo Box
I want the user to select one of many options. So first I used I drop down combo box. I didn't like it because the user could enter something. So I changed it to a drop down list combo box. The user can't add anyhting now. My question is how do I reset the textbox? When I start the program the box is blank but once the user selects something is there any way to reset it? I can't make it equal to "".
Any ideas?
Thanks, AL
Picking A From A Drop List
How can I have a Macro prompt the user for a value that is part of a dropdown list and make the macro pause at that cell until selection is made. I'm trying to "Step" the user through a form.
Thanks
Mike
Drop Down List In A Cell
I am trying to accomplish the following:
Excel Workbook has two sheets. The second sheet has accounts and account numbers in Columns A and B.
I would like to have these account numbers included in a drop down menu in cell B5 on the first sheet. I have not been able to accomplish this. I have been able to make this work when everything is on one sheet using the following code:
Dim tmpForm As String
Public Sub Add_Menu()
tmpForm = "=A35:$A48"
Range("B5").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:=tmpForm
.InCellDropdown = True
.ShowInput = True
.ShowError = True
End With
End Sub
Any suggestions would be greatly appreciated.
Drop Down List And Worksheet_change Bug?
Hi,
I'm having a problem and it's to do with worksheets_change and data validation. I know there was a bug in older versions of xl but I'm using 2003 and the problem there (from my reading) was that it wasn't recognising changes to lists as changes to the worksheet.
Anyway the problem is that I want to show and hide rows in a sheet depending on the value selected from a dropdown box. What I've done is as follows:
Private Sub Worksheet_Change(ByVal Target As Range)
'Make sure the right things are displayed
Select Case Range("list").Value
Case "first one"
Rows(8).Hidden = False
Rows(9).Hidden = True
Case "second one"
Rows(8).Hidden = True
Rows(9).Hidden = False
End Select
End Sub
Where list is a cell with data validation set to list.
It recognises (when the list is changed) that there has been a change in the worksheet, kicking off the sub, but it doesn't actually do the hide/unhide.
Anyone got any ideas?
Thanks
Si
Drop Down List Trouble!
Hi, heres my scenario
In MS EXCEL I have a sheet called "TeamDetails" which contains 4 cells which contain the name of 4 snooker teams. They are not located adjacent to each other however. n e ways i have another sheet called "MatchSchedule". Here using one cell i wish to right click the cell and from the menu create a drop down list.
Now the problem is how do i select the name of the teams from the other sheet to appear inside the drop down list????
Drop Down List Combo
hi, i think i shoud use a dropdown list combo since the user cannot then enter any values outside the range, so less errors!
but how do i enter a value in the text field? since it is not possible to add text into this kind of combo? i mean for instance a combo with values 1 tp 5 but with 3 preselected, so that the combo is not empty?
Ultragrid Drop Down List
Hello All,
I was trying to figure how to create a drop down list for a grid I have created. The drop down list will only be used for one column on this grid, but each cell in this column will used this same list to select options from. The options of this drop down list will contain a recordset I am passing into to it. Does anyone have any suggestions on how I can code this, because I am having alot of difficulty with it at the moment. Thanks for any help you can give.
Autocompleting A Drop Down List
I have a cell linked to a range so that when you click on the cell you have to pick one of the options from the drop-down list (the drop-down list contains the items in the range).
Is it possible to set up Excel so that if a user begins to type in the cell it will autocomplete to one of the items in the range.
For example, let's say the items in the range were "orange" and "apple". Right now the user has to either type one of these items as exactly as it is entered or select the item from the drop down list. Is it possible to set up the cell so that the user can start typing "or" and excel goes ahead and completes it with "orange"? Kind of like when you are typing a web address in Internet Explorer.
Drop Down List/combo
this is what i want to do
i dunno how to make it ezr but i am planning to use 1 dropdown list to store a name and once you select that name it will display the address and postal code in other field
EG:
JOHN MURPHY (selected)
(display)
9847 nowhere rd (different dropdownl list/textbox)
new york, new york (different dropdownl list/textbox)
12345 (different dropdownl list/textbox)
if i want to do this i need to store the data into a file...how would I be able to do this?
anyone able to help?
icq 1397831 asap!!!
thank you in advanced
Drop Down List Question
I have a dropdownlist databinded and it has many values "Please select..." , "Milwaukee", "Chicago".... and many other citys.
So how do I show an error if they click the submit button without changing it from "Please select..."?
Thanks and if you need any other info please let me know,
Schmidty
I am using .Net 2003
The Most Effective Way To List In A Drop-down Box?
What is the most efficient way to list items in a drop-down box? Is it through a textfile/ access file/ or putting it in the program? I've got a 26 name list that may vary in the future. I'm thinking of putting a drop-down box on my form and the data pulling from a text file.
If that is the most efficient - What would be some of the code to do that and MORE IMPORTANTLY- when and where should I put it?
I would think pull it up (OPEN "textfile) in Form_Load and use array variables to represent the data. let's say Dim A(26) as String: For I = 1 to 26: INPUT#1, A(I):NEXT I. Now how to list those variables in the Drop-down box? And where - Private Sub List_Box()?????????
Thanks for any info.
Stephen
Listview Drop Down List..
hello, is there any code how can i make a drop down list in a listview? just like adding a new row? help pls?
Reset A Drop Down List
Hi,
i have a combo box and have set its property value to Drop down list. the problem is that when i save the values, i clear the contents of all controls
how does one reset a drop down list to the original state to be the way it was when the form was loaded.(i.e no value is selected)
ComboBox -- Drop Down List
Style is (2) Dropdown list, so I can edit the combobox.
I have a list of different items in a Drop down list.
When a form loads it should check if xName is in that combolist. If it is, then select it to be shown (in combobox.text). However the .text doesnt work as Dropdown list is read only. But is there a way to make this work?
And another question, how do I remove all items in a dropdown list without specify all lines?
like combobox.removeitem all or something
MultiSelect From A Drop-Down List
Hello all,
Can I MultiSelect from a Drop-Down List? From what I find, I can only MultiSelect from a List Box. The Drop-Down List is generated in the Combo Box. Please help!
Auto Drop-down List...
Hi All and thankyou for viewing my post,
Can a drop-down menu list be narrowed down.. for instance,
If i have a drop down menu for all car makes, in this example we select, BMW; can the model dropdown menu list be narrowed to all the BMW models; M3, 5-Series, 7-Series.. etc...
Any help appreciated...
Thankyou..
Amer
Question About Drop Down List?
If I have a drop down list how could I code it so if I started to enter the first few charters it would drop down to that item within the list?
How Do I Make A Drop-down List?
Hi, I've never made a drop-down list before and I was wondering whats the easiest way to create one. I need one that is expandable through code and I'd like some sample code on how to tell which item is being selected.
Thanks!
Drag And Drop Between Two List Box
Hi all,
I am currently using command buttons to tell my program
to transfer the contents of one listbox to another.
How could I do the drag and drop function between two listbox?? Thanx in advance.
Creating A Drop Down List With A Label.
Yes...I am creating a program, and i am wondering how to create a drop down list, while using a label. I prefer not to use a combo box, bc i do not, like the feel of it. Id very much appreciate, if you could help me.
Drop Down/ Combo Box Colour List
Hi All,
I wonder if you can help.
I'm trying to create a list (drop down, combo box or otherwise) that displays all the preset colour names (i think theres 25) with each of their backgrounds the same as their relevant colour! Can anyone help?
Many Thanks
Drag + Drop With List Views
I am trying to drag and drop from one list view to another.
Using the listview's mousedown, dragdrop and drag over events I can manipulate single list items ok.
My problem is when I try to move multiple items.
If I select the list items I need with the keyboard - no problem, but when using a combination of Shift/CTRL + mouse click to select the mouse down event fires and my drag begin code runs.
Remove Item From Drop Down List
On my site I have a drop down list (set to multiselect) which lists all of my users and I want to be able to select as many users as I want in the drop down list then click a button to remove them.
Can anyone help me out?
Thanks.
Drag-n-Drop List Box Items
Is this possible? I have a list box that contains 'items' that involve 4 pieces of data and I want to drag them from one list box to another. Is this possible? What settings do I have to use and how? Thanks!!!
|
TRACKER
