Vba how to set this value cell in my value ?
Hi,
i have done an example drop down where if user select drop down list A they be given to select based on the grouping, now however i want to target this column cell value as = 1 of my drop down
i have put the instruction down in the excel marco can someone help me out from the vba to add on this ?
i have try this vba code
Please Login or Register to view this content.
Last edited by excelvbanew; 04-27-2023 at 01:55 AM.
In previously supplied code...add red snippet...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Nice is there a way where i can auto refresh the column C as well if i select on 4D i can still see "Sale (Default)" is there a way i can refresh the cell by cell ? in column C ?
since in my scenario is 1 whole table ..
Last edited by excelvbanew; 04-27-2023 at 03:00 AM.
I don't understand...please explain this in more detail...
sorry is a bit hard to explain
basically i have added more row to it
and i wan a drop down refresh when select the column A drop down
i also have updated the code whatever you have send which have solved most of my issue, now currently left is this where i wan try to refresh the drop down based on the selection i make .
Last edited by excelvbanew; 04-27-2023 at 03:26 AM.
Explain step by step what you want to achieve by referring to each individual action...I am not a mind reader...
Example
I Select in Column 4A i select 3G first which give me "Sale (Default)"
now i reselect in Column 4A i select 4D which i should see the new value however "Sale (Default)" is still there
so now i would like to try to update the new column in C4 to make it = ""
and the following same row which also same but it refresh in that row
so if i choose 4A in row 2 = "Sale (Default)"
then row 2 i change to 4D = "" if i change this in my 4d this row get updated
hope this help to explain what i wan
What new value...The first of the next list...which i should see the new value
NA - No tangible assets
do you want A4:A9 to have the same functions...so if i choose 4A in row 2
yes correct
as this will be like in a table for the user to choose
like this...
Hi sorry i cant view the file as is block by my company due to virus found
can u paste the code instead in here ?
Please Login or Register to view this content.
yes it work as what i want
Thanks again for itCheers .
...............................
THANKS.gif
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks