ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,726
- Office Version
- 2007
- Platform
- Windows
Hi,
Some info for you.
I have a userform with the following.
ComboBox1
ListBox1
ImageBox
I wish to clear the ImageBox when i first / each time make a selection from the ComboBox
I have tied this below but get a RTE 438
So i make a ComboBox selection.
I then make a selection from the ListBox & its relevant image is loaded.
Now i wish to make a different selection from the ComboBox, It is now i wish to clear the ImageBox
Some info for you.
I have a userform with the following.
ComboBox1
ListBox1
ImageBox
I wish to clear the ImageBox when i first / each time make a selection from the ComboBox
I have tied this below but get a RTE 438
Rich (BB code):
Private Sub ComboBox1_Change()
Dim index As Integer
index = ComboBox1.ListIndex
ListBox1.Clear
ImageBox.Picture.Clear
Select Case index
Case Is = 0 ' AIR BLADE
With ListBox1
.AddItem "AIR BLADE 2018-2019"
.AddItem "AIR BLADE 2020-2021"
.AddItem "AIR BLADE 2022"
End With
Case Is = 1 ' CBR
With ListBox1
.AddItem "CBR 1000 2021"
End With
So i make a ComboBox selection.
I then make a selection from the ListBox & its relevant image is loaded.
Now i wish to make a different selection from the ComboBox, It is now i wish to clear the ImageBox