Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Volatility With Comboboxes?
You can break the rowsource / controlsource links and populate your combobox
using code Private Sub Userform_Initialize() With Worksheets("Data") set rng = .Range(.cells(1,1),.Cells(1,1).End(xldown)) End With me.Combobox1.List = rng.Value End Sub Private Sub Combobox1_Click() worksheets("Data").Range("B9").Value = _ me.Combobox1.Value End Sub -- Regards, Tom Ogilvy "MDW" wrote in message ... Hey all, I've got a minor issue with a workbook. I've got a userform with a combobox that gets its content from a range on the worksheet. It's a static range; no one else uses the workbook but me and I don't need to change the content. Every time I try to close this sheet, I get a pop-up that says "Would you like the save the changes you made in ...?" I can only assume that the "changes" are due to the fact that the combo box is being dynamically populated every time I open the form. Is there anything I can do to stop this from happning? Ideally, if there's a way to simply hard-code the options into the combo box like you can do in Access, I'll take it. -- Hmm...they have the Internet on COMPUTERS now! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to plot volatility in Excel | Charts and Charting in Excel | |||
RAND() Volatility | Excel Discussion (Misc queries) | |||
Removing Volatility | Excel Worksheet Functions | |||
volatility calculation | Excel Worksheet Functions | |||
volatility | Excel Discussion (Misc queries) |