Hello everyone,
I'm struggling to get this code working. What I am trying to do is create an Input box for the user to select data from two cells, then copy this data and paste it to another sheet that contains a table. I need it to paste directly below the table so it expands and captures the information. Please see what I have so far, below. The code stops at the .range ("x) line.
Any help would be greatly appreciated!
Please Login or Register to view this content.
Hi, you don't past under a table you insert into the table after the final row.
I suggest your read this article, it's long but it explains everything about using tables and addressing tables in Excel with VBA
I can come up with many solutions, but if you take the time you'll see it's not that difficult, it's just the way you approach a real table as listobject
https://www.thespreadsheetguru.com/b...t-excel-tables
After that ... I'll gladly help you on
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Super good read. Appreciate the link! After reading thru I see how I asked the wrong question and stumbled across something that could potentially be more effective. I didnt realize you could insert into a certain row. How would I structure this code to insert into the first row? The secondary Item I haven't worked on is the password unlock and lock when finished. Do you think thats possible? Their are columns on the table that need to stay protected.
Basically I'm copying 2 cells that the user selects and inserting them into the first two columns on a table in another sheet.
Below is what I am slowly coming up with, missing component is how do I get it to paste in to the range? I've tried a few variations and it isn't working.
The other issue is its locking the selected cells after. I want to lock the sheet but have those cells remain unlocked. I'm guessing someone has a
way better option than my code. Newbie here....
Please Login or Register to view this content.
What you need to so is specify the raneg of cells that remains unlocked before you protect the worksheet.
You can do this manually, select those cells that will not be locked and the protect the worksheet allowing only the unlocked cells to be selected.
You can do this once manually using the same password as you have in the code then when the van code protects it it remains that wya.
Add the following parameter to the protect this will permit VBA code to edit ANY cell without needing to unprotect the sheet when using vba.
Hope this points you in the right directionPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks