Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings,
I am trying to update an item in the ComboBox1 list and get this error message: ------------------------------------------------------------------------- Run-time error '70': Could not set the List property. Permission denied. ------------------------------------------------------------------------- With this code: --------------------------------------------------------------------------------------- ComboBox1.List(ComboBox1.ListIndex, 2) = TextBox1.Value --------------------------------------------------------------------------------------- When I run this MsgBox --------------------------------------------------------------------------------------- MsgBox "TextBox1 = " & TextBox1 & " and ComboBox1 = " _ & ComboBox1.List(ComboBox1.ListIndex, 2) --------------------------------------------------------------------------------------- Just above the line of code that chokes, it shows that the ComboBox and the TextBox have the same value. What do I need to do to fix this code? Any help is appreciated. -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Syntax for selecting a textbox within a chart? | Charts and Charting in Excel | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Userform: Textbox changing with selection in combobox (list) | Excel Programming | |||
Help with Syntax UserForm TextBox | Excel Programming |