This worked on my userform, and the combobox loaded the countries. Me.ClientNameComboxAdd.RowSource = "RangeCombobox" The plan should be clear and concise and should outline step-by-step instructions for spill containment, material cleanup and disposal, documentation, reporting, and follow-up procedures. Then try Private Sub UserForm_Initialize() When a spill happens, it is critical to have a detailed plan in place. Maybe it can help you out with your issue. Another option you have is doing the same I did but activate first the macro recorder and check the code. Hope this can give you a light in your task. Now final test, I inserted 2 new records in my table (China and Japan values) and the combobox updates instantly, by just adding records to my table. Third step is testing if the combobox get the values of the Country Column, and it does: In my case is just "=T_DATA".Īfter that, I Inserted the combobox and Right click on it, tab CONTROL, and I set the Entry Range as the named range I created before, in my case, RANGECOMBOBOX: You have to make sure this named range refers to the column of your table. Just Excel 100%.įirst, I created a Table named "T_DATA" with 2 columns, COUNTRY and CONTINENT, and after that I added 3 records: Country ContinentĪfter that, I created a Range named RANGECOMBOBOX, and source is the Country column of my table. The first part, which comes into play before clients are added to the table, seems to work fine. The problem is in the next-to-last line - ClientNameComboxAdd.RowSource. MsgBox "Can't Add a New Plan With No Clients Entered"ĬlientNameComboxAdd.RowSource = sht.ListObjects("Clients").ListColumns(1).DataBodyRange If LastRow = 2 And sht.ListObjects("Clients").DataBodyRange(1, 1) = "" Then Set sht = ThisWorkbook.Worksheets("Client Info") Any thoughts on what I am doing wrong? Private Sub ClientNameComboxAdd_Enter() I suppose I could use a loop and AddItem statements, but since I expect this to get large (several hundred entries), would prefer to stay away from loops that might slow down the execution. 07-29-2008, 07:51 AM abayman65 Member Join Date: Jul 2008 Posts: 44 Pro Control VCA group Spilling Hi there, Does anyone know how to spill out the members of a VCA group master on an 8 fader Pro Control main section - running 7.3.1 (You can do this on an Icon/Dcommand by pressing bypass on a VCA fader which spills out the channels in this group). I am trying to fill a ComboBox with selections equal to the first column of a data table, and keep getting
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |