Hi,
I've require solution to above subject line with and without VBA while working on TextBox inserted through developer.
Thanks
R_Know
Lock Text for copy and allowed to Scroll.xlsm
Hi,
I've require solution to above subject line with and without VBA while working on TextBox inserted through developer.
Thanks
R_Know
Lock Text for copy and allowed to Scroll.xlsm
Can you please elaborate on what exactly are you hoping to do?
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
attached file, having textbox which having text, it has to be read with scroll function in that textbox.
But user does not allowed to copy text from text box and does not allowed to delete TextBox.
Rudimentary. But adding this code seems to be working
Code:Private Sub TextBox1_GotFocus() ActiveCell.Select End Sub
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Put this code in Sheet1 module.
Code:Option Explicit Dim ClipBoard As MSForms.DataObject Private Sub TextBox1_GotFocus() TextBox1.WordWrap = False TextBox1.WordWrap = True End Sub Private Sub TextBox1_LostFocus() Set ClipBoard = New MSForms.DataObject 'hope one of these will work :) Application.CutCopyMode = False ClipBoard.Clear ClipBoard.SetText "" ClipBoard.PutInClipboard End Sub
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Thanks Admin
But It is allowing to copy from textbox, good thing only it wrap it...
Last edited by r_know; 08-17-2016 at 03:33 AM.
Can you check the code I posted. Like I said, it is rudimentary, but seems to be working.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Please check whether it allows to paste.
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Bookmarks