[VBA] 2 questions for VBA Excel

[boris2004]

Hey

my first question is, is their a way to link a cell to a combobox in a form, like a normal combobox on a excel sheet?

my second question is, i need to check about 5 different cell ranges in 5 different rows and if their is some information in that cell range i need to be able to check the next row down and if that range is empty then add information in not check next row and so on...

Cheers,
Bori

 

[al_b_cnu]

Hi, Welcome to the board.

In answer to your questions,

1) try the ControlSource property of your Combobox.

2) This code:

Dim R as Range

. . .

For Each R in Range("A1:A5")
if R.offset(1,0).value="" then ... 'the adjacent row is empty
If R.Offset(0,1).value= "" then ..... 'the adjacent column is empty
next R


HTH

Alan

 

[boris2004]

Cheers for that, it worked fine!!




Cheers,
Boris