By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,988 Members | 1,493 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,988 IT Pros & Developers. It's quick & easy.

ComboBox List Remover on Select

P: 1
This code is used in conjunction with an excel spreadsheet, i need to be able to remove each item from the comboBox list as the item is selected this can be in any order and if and when the last item is selected runs an additional macro called FileSaveNewer()
The code is;
Sub SelectTest()
UserForm3.ComboBox3.Clear
UserForm3.ComboBox3.AddItem "A C"
UserForm3.ComboBox3.AddItem "X C"
UserForm3.ComboBox3.AddItem "E C"
UserForm3.ComboBox3.AddItem "A C C"
UserForm3.ComboBox3.AddItem "X C C"
UserForm3.ComboBox3.AddItem "E C C"
UserForm3.ComboBox3.AddItem "A E T"
UserForm3.ComboBox3.AddItem "X E T"
UserForm3.ComboBox3.AddItem "E E T"
UserForm3.Show
Range("B110").Value = UserForm3.ComboBox3
Select Case Range("B110")
Case "Azimuth Clockwise"
'UserForm3.ComboBox3.RemoveItem "A C"
Call GetInputACW
Case "X C"
Call GetInputXCR
Case "E C"
Call GetInputECR
Case "A C C"
Call GetInputACCW
Case "X C C"
Call GetInputXCCR
Case "E C C"
Call GetInputECCR
Case "A E T"
Call ATestAmps
Case "X E T"
Call XTestAmps
Case "E E T"
Call ETestAmps
End Select
End Sub

Can anyone help this is driving me crazy!
Dec 3 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.