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! |
All times are GMT +1. The time now is 12:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com