LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 60
Default setting rowsource

I have 5 combo boxes that must have the same rowsource

When I try to program this in VBA, the first one works but then after that I
receive the 424 Errror. I can't manually set it because the range changes, so
i have the code set up to get the last cell...

if anyone could help me that would be great....

Private Sub FillOrders(intLa As Integer)

cmbISBN1.RowSource = "Pinder!E2:E" & intLa
cmbISBN2.RowSource = "Pinder!E2:E" & intLa
cmbISBN3.RowSource = "Pinder!E2:E" & intLa
cmbISBN4.RowSource = "Pinder!E2:E" & intLa
cmbISBN5.RowSource = "Pinder!E2:E" & intLa

End Sub
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combobox rowsource Marinos Andreou Excel Programming 2 March 7th 06 05:08 PM
help with rowsource GMet Excel Programming 4 September 24th 04 02:30 PM
combobox rowsource Newbie Excel Programming 1 September 8th 04 12:21 PM
Could not set the RowSource property Tom Ogilvy Excel Programming 0 August 17th 04 07:48 PM
Using IF, Then with rowsource? CAA[_23_] Excel Programming 8 April 4th 04 08:56 PM


All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"