| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anyone in a really good mood?
Hey my very smart friends,
i have alist box question i have asked a few times and I just can't ever seem to get the answers to work. Is there anyone out there in a totally generous mood who would mind me sending them a totally generic workbook and they show me how to fill this stupid thing the way I need it filled in a user form? 1.User open a user form 2.From a combo box (ComboBox1) choose a Farmers Market ID (lets say they choose Beverly Hills) 3. The list box is then populated with three columns from the worksheet (Sheet1) that has info about: Date Boxes Taken Fruit Variety Etc. The list box would only populate with info that pertained to beverly hills of coarse. Lastly if they change the info in the list box will it then be reflected in the worksheet? Thank you guys. Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Anyone in a really good mood?
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Anyone in a really good mood?
Hi Jennifer
The task seems pretty straightforward, you could send the workbook or supply the worksheet references to the following The worksheet range containing the market names (IDs), and the worksheet range containing the three columns to list in the list box. I presume you require the changes made to the list box entry to be placed back into the same place on the worksheet? This may not be good practice without some validation - do you know what that should be? The method I normally use to manage changes like this is allow the user to double-click the list entry, which opens an editor panel to allow changes to be made, these can then be validated before being written as a new item in the list. The old (now edited item is marked for deletion) - the 'deleted' items are not listed again but allow the administrator to validate changes and if required remove them. HTH -- Cheers Nigel <remove xxnospamxx from address to mail me "Jennifer" wrote in message ... Hey my very smart friends, i have alist box question i have asked a few times and I just can't ever seem to get the answers to work. Is there anyone out there in a totally generous mood who would mind me sending them a totally generic workbook and they show me how to fill this stupid thing the way I need it filled in a user form? 1.User open a user form 2.From a combo box (ComboBox1) choose a Farmers Market ID (lets say they choose Beverly Hills) 3. The list box is then populated with three columns from the worksheet (Sheet1) that has info about: Date Boxes Taken Fruit Variety Etc. The list box would only populate with info that pertained to beverly hills of coarse. Lastly if they change the info in the list box will it then be reflected in the worksheet? Thank you guys. Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Anyone in a really good mood?
Hey Nigal,
Patrick just answer the question about filling the list box. Yep, pretty straight forward. Sometimes i just have to see it in action for it all to make sense. Your idea about managing the changes sounds great. Can you get me going. The worksheet range containing the market names and the range with the three columns are all on the same worksheet. Named Database You presume correctly that I want the changes placed back in the database. Thank you, Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer "Nigel" wrote: Hi Jennifer The task seems pretty straightforward, you could send the workbook or supply the worksheet references to the following The worksheet range containing the market names (IDs), and the worksheet range containing the three columns to list in the list box. I presume you require the changes made to the list box entry to be placed back into the same place on the worksheet? This may not be good practice without some validation - do you know what that should be? The method I normally use to manage changes like this is allow the user to double-click the list entry, which opens an editor panel to allow changes to be made, these can then be validated before being written as a new item in the list. The old (now edited item is marked for deletion) - the 'deleted' items are not listed again but allow the administrator to validate changes and if required remove them. HTH -- Cheers Nigel <remove xxnospamxx from address to mail me "Jennifer" wrote in message ... Hey my very smart friends, i have alist box question i have asked a few times and I just can't ever seem to get the answers to work. Is there anyone out there in a totally generous mood who would mind me sending them a totally generic workbook and they show me how to fill this stupid thing the way I need it filled in a user form? 1.User open a user form 2.From a combo box (ComboBox1) choose a Farmers Market ID (lets say they choose Beverly Hills) 3. The list box is then populated with three columns from the worksheet (Sheet1) that has info about: Date Boxes Taken Fruit Variety Etc. The list box would only populate with info that pertained to beverly hills of coarse. Lastly if they change the info in the list box will it then be reflected in the worksheet? Thank you guys. Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Anyone in a really good mood?
Patrick,
At least make it look a little difficult to make me feel better. Ha! -- Though daily learning, I LOVE EXCEL! Jennifer "Patrick Molloy" wrote: see if this works... http://www.xl-expert.com/files/simpleform.xls "Patrick Molloy" wrote: send to me at "Jennifer" wrote: Hey my very smart friends, i have alist box question i have asked a few times and I just can't ever seem to get the answers to work. Is there anyone out there in a totally generous mood who would mind me sending them a totally generic workbook and they show me how to fill this stupid thing the way I need it filled in a user form? 1.User open a user form 2.From a combo box (ComboBox1) choose a Farmers Market ID (lets say they choose Beverly Hills) 3. The list box is then populated with three columns from the worksheet (Sheet1) that has info about: Date Boxes Taken Fruit Variety Etc. The list box would only populate with info that pertained to beverly hills of coarse. Lastly if they change the info in the list box will it then be reflected in the worksheet? Thank you guys. Jennifer -- Though daily learning, I LOVE EXCEL! Jennifer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| And in case I don't see you,good afternoon,good evening,and good n | Excel Discussion (Misc queries) | |||
| Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good | Excel Programming | |||
| Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you | Excel Programming | |||
| Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you | Excel Programming | |||
| Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you | Excel Programming | |||
Linear Mode
