SiddersAtCHEP
Board Regular
- Joined
- Nov 2, 2005
- Messages
- 104
Hi
Can anyone help with this. I have some macro code developed in 2003 which doesn't seem to work in 2007.
This routine is called and I pass over the TopAdd and BottomAdd
Sub MakeProdList(TopAdd, BottomAdd)
MyListFillRangeString = "'Priced GTL v2.0'!" & TopAdd & ":" & BottomAdd
Sheets("Activity Breakdown").cbxProdList.ListFillRange = MyListFillRangeString
Sheets("Charge Summary").cbxChargeSum.ListFillRange = MyListFillRangeString
Sheets("Amended_Rejected Transactions").cbxAmendReject.ListFillRange = MyListFillRangeString
Sheets("Activity Summary").cbxActSum.ListFillRange = MyListFillRangeString
End Sub
You can see that this creates a string that I want to put into the ListFillRange property of a combo box. On each of the sheets, I use the code that works perfectly well in 2003 but in 2007, it does not change the ListFillrange property to the required data.
In fact, when I go into the combo box manually and get the properties box showing, it won't let me edit the ListFillrange. Actually, I also tried editing the LinkedCell property and the moment I pressed <Return> it blanked that box out as well. So, in effect, I do not seem to be able to edit these values.
Why?!
What would I need to do to rectify this?
Many thanks to anyone who can point me in the right direction.
Sidders
Can anyone help with this. I have some macro code developed in 2003 which doesn't seem to work in 2007.
This routine is called and I pass over the TopAdd and BottomAdd
Sub MakeProdList(TopAdd, BottomAdd)
MyListFillRangeString = "'Priced GTL v2.0'!" & TopAdd & ":" & BottomAdd
Sheets("Activity Breakdown").cbxProdList.ListFillRange = MyListFillRangeString
Sheets("Charge Summary").cbxChargeSum.ListFillRange = MyListFillRangeString
Sheets("Amended_Rejected Transactions").cbxAmendReject.ListFillRange = MyListFillRangeString
Sheets("Activity Summary").cbxActSum.ListFillRange = MyListFillRangeString
End Sub
You can see that this creates a string that I want to put into the ListFillRange property of a combo box. On each of the sheets, I use the code that works perfectly well in 2003 but in 2007, it does not change the ListFillrange property to the required data.
In fact, when I go into the combo box manually and get the properties box showing, it won't let me edit the ListFillrange. Actually, I also tried editing the LinkedCell property and the moment I pressed <Return> it blanked that box out as well. So, in effect, I do not seem to be able to edit these values.
Why?!
What would I need to do to rectify this?
Many thanks to anyone who can point me in the right direction.
Sidders