Jabberwokki
New Member
- Joined
- Dec 2, 2020
- Messages
- 33
- Office Version
- 2010
- Platform
- Windows
Hi there
Newbie posting for the first time so apologies if I don't provide the required detail....
I have the following code written in a module to select a number of macros based on the selection in the Shapes.ComboBox.
Sub TFSStatus_Change()
Dim c As ControlFormat
Set c = Sheet1.Shapes("TFSStatus_ComboBox").ControlFormat
'Choose which macro to run based on the selected value in the combobox
Select Case c.Value
Case 1: ipTimestamp
Case 2: compTimestamp
Case 3: backlogTimestamp
Case 4: blockedTimestamp
Case 5: nrTimestamp
End Select
End Sub
I'm looking to apply a default background and font colour (pre selection) and then a background colour change based on the combobox selection...
Any help would be greatly appreciated.
Regards
D
Newbie posting for the first time so apologies if I don't provide the required detail....
I have the following code written in a module to select a number of macros based on the selection in the Shapes.ComboBox.
Sub TFSStatus_Change()
Dim c As ControlFormat
Set c = Sheet1.Shapes("TFSStatus_ComboBox").ControlFormat
'Choose which macro to run based on the selected value in the combobox
Select Case c.Value
Case 1: ipTimestamp
Case 2: compTimestamp
Case 3: backlogTimestamp
Case 4: blockedTimestamp
Case 5: nrTimestamp
End Select
End Sub
I'm looking to apply a default background and font colour (pre selection) and then a background colour change based on the combobox selection...
Any help would be greatly appreciated.
Regards
D