hi all, please see the attached document. I currently have sheet 2 which has a drop down list. When an item is selected it brings up information relating to the client name. (Data is on sheet 1) the problem i have is i want to have the cells editable. So say when i choose Clark from the client name and it brings up his details, i want to be able to edit those details and it update the table in sheet 1 from me editing the cells on sheet 2? Is this possible?
VBA or FORMULA? Help!
- JJeffery99
- Thread is marked as Resolved.
-
-
-
You cannot edit data returned by a formula without overwriting the formula. You could use VBA but why not simply edit in the Table?
-
Hi Roy,
How would i go about writing a VBA code for this? The reason being i am simplifying it for my colleagues, the table will contain far more data than shown and have a lot of text and i dont want them to see that page at all apart from the relevant bits if you are with me.
-
What about a UserForm?
-
In all honesty i have never used a user form before, would it solve my issue?
-
-
I'll add one for you tomorrow
-
Here's a UserForm to amend entries.
It can easily be adapted to add new entries if required
-
hi roy, this does help! is it possible or could you explain how i may get headings on the user form, different box sizes etc and also to have that user form already on sheet 2 without having to click a button to bring it up?
Thanks so much for your help!
-
You can change the box sizes by opening the VB Editor you will see the UserForm. You can add controls, code and change sizes there.
I've added Labels for you.
Also added code to show the userform when the sheet is activated
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!