Move commandbutton to up or down to range is selected by combobox on userform

Hello
yesterday I got help by Marc in this thread
https://www.excelforum.com/excel-pro...x-on-form.html
when I select name form combobox1 will match name with column I and show the range without using scroll bar. now I want when show the range as if it's in first range should move command button to next to range because if I close form and will run again I don't want to have to move up to click command button especially if the range is down
in other meaning when show the range so should move command button to beside the range is showing.
in picture 1 this what code does it now
in the picture2 what I want it.

thanks

Well works on my side with this thread attachment …

really strange !!
and will shows error object required after close userfrom in this line

Please Login or Register  to view this content.

According to post #1 attachment this codeline can't be activated when the userform is closed as located in your ComboBox1_Change event.

Still according to post #7 for good enough readers :

Originally Posted by Marc L

According to post #1 attachment this codeline can't be activated when the userform is closed as located in your ComboBox1_Change event.

As your attachment does not contain a CommandButton1_Click event …

Originally Posted by Ali-M

you mean the code is not existed in CommandButton1_Click event ?

No you misread again as I wrote CommandButton1_Click event does not exist !
So just open your post #1 attachment of this thread and check !

Originally Posted by Ali-M

I asked you in post#8 , I don't get clear answering .

Already answered in posts #5 & 7 if you had well read them !

Originally Posted by Ali-M

I understand from your comment in post#9 the code is not yours totally.

Wrong, you misread / misunderstood again and how by hell is it possible you deduced that with my post #9 ?‼
No sense at all …

Originally Posted by Ali-M

if I put in your code in CommandButton1_Click event the same error continues show

Why as again this event does not exist in this thread post #1 attachment ?‼
Only my post #2 stated to your previous thread …
But not my next post as explicitly explained again & again since post #5 !


As it well works on my side - whatever in which VBA procedure - just inserting the post #3 red codeline
so the weird is on yours and I can't guess what you have badly done except misreading, not following the directions …

( removed as the forum does not well work when uploading a gif video file …)

if you don't attach the video then you can't help me and I can't find my bad !
now I misunderstood totally in post#3
when you comment in post#2 I connect it with post#3 then I put like this

Please Login or Register  to view this content.

that's why shows error , but after I see the video then snipped red should be in ComboBox1_Change
sorry it takes more time to understand your suggestion
now your code works excellently
thank you so much .

As explained in posts since post #5, post #3 stating for inserting only the red codeline and not all ‼
Solution always comes to good enough readers …