Hi
I have a Private Sub Worksheet_Change(ByVal Target As Range) macro that is not working.
Basically this code is referencing a cell on another sheet so it is not activating. Does anyone have any ideas I may try?
If the cell is in the same sheet press F2 then enter the code works. But as the cell is on a different sheet nothing happens
Many thanks!
Hi,
It would be a big help if you could share the procedure code with us.
Better still upload the workbook and tell us which sheet is involved.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
If you wish to use the change event it must be in the sheet where the cell is being changed. That is unavoidable.
Hi Richard,
Attached is my workbook
Sheet1 contains the TextBox which references named cell on Sheet2 "Companies"
What I want to achieve....
"Companies" contains a formula which will pick up any changes to the list of Companies YELLOW
The TextBox does register the change but truncates to ONLY the first 255 chars. The code was to make TextBox have more than 255 chars
I hope I am making sense and thank you for any assistance you may give.
Hi,
Why do you need to use a Drawing shape and jump through all the hoops of VBA code.
Why not just merge a range of cells (one of the very few occasions I would encourage this), and choose 'wrap text' - say E9:N18 on sheet1 then in E9 use the formula =Companies
Yeah I did decide to do this in the end
Thanks Richard for your time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks