Moving items between ListBoxes

[Boechat]

Good afternoon,

I am working on a form containing three listboxes. I have created buttons to be able to freely transfer data from one listbox to another, but I'm stuck at the code. The data that populates the listboxes upon form activation comes from different worksheets in the same workbook. So,when I transfer an item from one listbox to another, the code is supposed to delete the entire row from one sheet and paste it to the destination sheet. After that the form reloads and the listbox is populated with the realoted results.

I have seen some guides on how to create "move to the right" or "move to the left" buttons, but they don't seem to realy apply since they don't effectively transfer the original data between the sheets.

So far I came up with this code, it does function on the first time, but then the row count starts playing off. Besides the form doesn't refresh, so I need to close it and open again to show the updated lists. Code folows below:

Please Login or Register  to view this content.

Any ideas?

(Crossposted from http://www.mrexcel.com/forum/excel-q...ml#post4589188)

[MarvinP]

Hi Boechat,

This sounds like you need to learn about Dynamic Named Ranges. You would then use the Name in your code which would span all the rows on the sheet.

http://www.ozgrid.com/Excel/DynamicRanges.htm
http://www.bettersolutions.com/excel...G820716330.htm

[Boechat]

Thanks, MArvinP.

Gonna give it a look right now!

[Boechat]

OK, I've tried naming my range now and to use it dynamically, however, I cannot get the range named. Excel seems to find an error on my formula and highlights the text in red for me:

=OFFSET($A$1,0,0,COUNTA($A:$A),COUNTA($1:$1))

What am I doing wrong?

[AliGW]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[Boechat]

Hello, AliG. I'm sorry, but I did reference the corssposting at the end of my post, not only here, but in the other forum as well.

Take a look a t last row in my post.

[MarvinP]

I can use your formula above in my workbook. Are you sure you are putting it into a NEW Name in your Names Manager found on the Formulas Tab?

https://support.office.com/en-us/art...2-ABD7FF379C64

[Boechat]

Thanks for your support, MarvinP. Thread has been resolved in the crosspost link!