Help with combobox

[Dexx]

I have 5 combo boxes on one sheet.
Is possible to change the index numbers?

I have
cbo1 1,2,3,4,5
cbo2 1,2,3
cbo3 1,2,3,4

but I need

cbo1 1,2,3,4,5
cbo2 6,7,8
cbo3 9,10,11,12

Also, in a macro, how can I check if one combobox is selected?
I need to copy the values of the celllinks into a db, but if one cbo is not selected the macro must stop, delete the inserted row and alert the user.

Thanx

[Bryan Hessey]

I have 5 combo boxes on one sheet.
Is possible to change the index numbers?

I have
cbo1 1,2,3,4,5
cbo2 1,2,3
cbo3 1,2,3,4

but I need

cbo1 1,2,3,4,5
cbo2 6,7,8
cbo3 9,10,11,12

Also, in a macro, how can I check if one combobox is selected?
I need to copy the values of the celllinks into a db, but if one cbo is not selected the macro must stop, delete the inserted row and alert the user.

Thanx

Hi,

this could be a case where a sample of your sheet (with your data removed) could be most useful, can you Copy the sheet and post a zip'd version here.

---

[Dexx]

here is a sample

[Bryan Hessey]

here is a sample

Hi,

just add a 'If' as per

Please Login or Register  to view this content.

Let me know how this goes

---
added, for the '6 7 8' & 9 10 11 12' the values in column L & M can be adjusted by you to suit your requirements, the cbo will display what you enter.
---

[Dexx]

That's what I needed. Thanx.

Just another Q about sheets.
I have about 15 sheets with a codeName (not tab name) Player1, Player2 Player3.

I need in a macro to do something like this:

Please Login or Register  to view this content.

I recive an error that an Object is required

[Bryan Hessey]

That's what I needed. Thanx.

Just another Q about sheets.
I have about 15 sheets with a codeName (not tab name) Player1, Player2 Player3.

I need in a macro to do something like this:

Please Login or Register  to view this content.

I recive an error that an Object is required

If I read that correctly, you are trying to set an array of Players, and then select something, probably a Sheet, according to the selected item.

I have not used arrays as "Players(1) = "Player2" "
but if the system allowed that, then try to select the object, viz


myPlayer = Players(num)
msgbox myPlayer & " to check"
myPlayer.select

that doesn't work, more tomorrow
---
amended, for CodeName

[Dexx]

Yes, Players are sheets

Let's say that I have 2 Sheets Named Player1 and Player2 (renaming the tab at the bottom.

This code Works:

Dim Num
Dim Players(1) as Variant
Players(0) = "Player1"
Players(1) = "Player2"

For Num = 0 To 1
Sheets(Players(Num)).Select
-- actions --
Next Num



But if one day I change the tab "Player1" into "Michael Jordan" the code above will not work.

What I need is to use the codeName of the Sheet, the value in (name)

At the end all that i need is a collection of sheets

[Bryan Hessey]

Yes, Players are sheets

Let's say that I have 2 Sheets Named Player1 and Player2 (renaming the tab at the bottom.

This code Works:

Dim Num
Dim Players(1) as Variant
Players(0) = "Player1"
Players(1) = "Player2"

For Num = 0 To 1
Sheets(Players(Num)).Select
-- actions --
Next Num



But if one day I change the tab "Player1" into "Michael Jordan" the code above will not work.

What I need is to use the codeName of the Sheet, the value in (name)

At the end all that i need is a collection of sheets

Using Codename, it works as

Please Login or Register  to view this content.

added, but your need for this might have been obviated by your other post (Collection of Sheets using the CodeName ).
---