Spreadsheet control with range

[anwarbham]

Hi all im having a tough time trying to figure out a way to select a range (which will be the entire row )based on a condition that will be data selected from a combobox and display that range in a userform with spreadsheet contol 9


what i have so far is a worksheet with all the data.
i have a combobox on a userform that is prefilled with data from a specific column

every thing is working except when i select the entire row how do i change that to a range that i can use in the spreadsheet control 9 that is added to the userform.

my code is below

Please Login or Register  to view this content.

[pike]

Hi anwarbham
change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

X will be a range to use

[shg]

anwarbham,

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with Code Tags.

[anwarbham]

Hi Iv tried the code but i get given invalid or unqualified refrance so

i have tried to change x to (siterange) that has been declared as a range in the top of the code

I have changed the code

Please Login or Register  to view this content.

i dont get any more errors But x has no value when i go through the code

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[anwarbham]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Dont understand my last post had the tags included

[shg]

Roy was referring to your first post, which you should still be able to edit to add code tags.

[anwarbham]

Roy was referring to your first post, which you should still be able to edit to add code tags.

cheers done

[pike]

maybe something like

Please Login or Register  to view this content.

[royUK]

This series of articles by Dennis Wallentin is about the best on the use of the Spreadsheet Control

[anwarbham]

Its ok i managed to fix the problem myself the solutions provided overhere were a bit too messy thanks for trying the final code is below for anyone else who might want to try some thing similar

Please Login or Register  to view this content.

[pike]

or instead of the sqaure peg in the round hole try

Please Login or Register  to view this content.