Sub not Function!

  • Thread starter Thread starter Zurn
  • Start date Start date
Z

Zurn

To make a comparison of two tests I want to put the values next to eac
other on a sheet.

To do that, I have two Combo Boxes with each the same 15 choises...yo
have to choose two different tests.

Now, I'm having a problem to make my code short:

-Dim leftChoise As Integer
leftChoise = Sheets("Keuze").Range("E1").Value
Dim rightChoise As Integer
rightChoise = Sheets("Keuze").Range("K1").Value

Select Case leftChoise

Case 1
PutLeftOnReport ("B7")
Case 2
PutLeftOnReport ("B29")
Case 3
PutLeftOnReport ("B51")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub, not function! 1
Sub, not function! 1
Expected:= ??? 1
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Insert row 2
Need help in printing vba code 0
Macro password-All sheets visible 4
Date ranges in VBA 2

Back
Top