I have a question about VBA Textboxes. I have added a textbox, locked it, plus im using a scrollbar.
Now when i scroll through, the textbox seems to bleed over at least another cell depth and stays there.
Can i stop this happening?
yes i got around it, which i shall add to the previous thread. I didn't merge the IF results together, just added a list of different cells in rows each using the IF function.
Well i swopped the merged cells for TextBox's, just added the linked text function cell address in the properties. Works great.. its just i noticed this bleed over. I can screen shot the properties on here if you think i should.
To be fully honest with you :
Photos are for Photoshop Forums ...
In an Excel Forum ... it is much better to attach ... well ... an Excel file ... :wink:
I was trying to show you, thinking you must have seen it many times before.. obviously not
A tiny sample file ... which replicates your problem ... would may be allow to visualize your problem ...
OK i have cut the spreadsheet down in size as much as i can, as i had loads of photo bitmaps, that made it quite big.
I tried to replicate the problem on another sheet but it wasn't doing it.. so here is the smallest part of the original without images.
TextBox 2......... If you scroll down it bleeds over a cells depth on the base.
There is a couple of merged cells in line with the base of the textbox (photo selector) but when i got rid of the merged cells it still bleeds over?
No way could i get it smaller than whats required on here so i RAR zipped it up
Hope another contributor will assist you ... since do not have software to Unzip ' RAR' files ... :crying:
I have just loaded onto Dropbox for you to download...
not used it before so here goes.................... Edit: forget that as it exceeds the file size haha
Tried Winzipping the file, but that just exceeds the limit on file size on here.
My only alternative would be to show a free down link for Winrar here.
Bonus is... it seems to compress down a lot more than Winzip at 3.5Mb and Winrar 1.7Mb
Okeh, perhaps you could advise me..
I don't think i am using the correct tool for the job.
I wanted to send text to my front page to be read only with a scrol bar as there is limited space.
So i can not lock a text box and use the scroller at the moment.. which is no good for the job.