Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Allow Bold & Italic in a textbox

Hi,
I have created a UserForm with a text box called 'FreeText1'. This text box
allows the user to input large chunks of data.

Q1. The ability to highlight text either in bold or italic.
Q2. Save the data into a cell on a spreadsheet as it appears in the textbox
with bold or italic prints
Q3. Populate that cell information into a Bookmark in Word.

Can this be achieved..

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Allow Bold & Italic in a textbox

None of it is supported by a textbox on a userform. You might be able to
link a cell to a bookmark.

--
Regards,
Tom Ogilvy

"LookingGood" wrote in message
...
Hi,
I have created a UserForm with a text box called 'FreeText1'. This text
box
allows the user to input large chunks of data.

Q1. The ability to highlight text either in bold or italic.
Q2. Save the data into a cell on a spreadsheet as it appears in the
textbox
with bold or italic prints
Q3. Populate that cell information into a Bookmark in Word.

Can this be achieved..

Thanks



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Allow Bold & Italic in a textbox

Thank you for your immediate response.

I thought it might be the case as I could not find any within the discussion
group.

by the way, how do one link a cell to a word doc bookmark, if I think it is?


Many Thanks

"Tom Ogilvy" wrote:

None of it is supported by a textbox on a userform. You might be able to
link a cell to a bookmark.

--
Regards,
Tom Ogilvy

"LookingGood" wrote in message
...
Hi,
I have created a UserForm with a text box called 'FreeText1'. This text
box
allows the user to input large chunks of data.

Q1. The ability to highlight text either in bold or italic.
Q2. Save the data into a cell on a spreadsheet as it appears in the
textbox
with bold or italic prints
Q3. Populate that cell information into a Bookmark in Word.

Can this be achieved..

Thanks




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Allow Bold & Italic in a textbox

I would look at Edit =Paste Special = Paste as Link for whichever
direction you are going.

--
Regards,
Tom Ogilvy

"LookingGood" wrote in message
...
Thank you for your immediate response.

I thought it might be the case as I could not find any within the
discussion
group.

by the way, how do one link a cell to a word doc bookmark, if I think it
is?


Many Thanks

"Tom Ogilvy" wrote:

None of it is supported by a textbox on a userform. You might be able to
link a cell to a bookmark.

--
Regards,
Tom Ogilvy

"LookingGood" wrote in message
...
Hi,
I have created a UserForm with a text box called 'FreeText1'. This text
box
allows the user to input large chunks of data.

Q1. The ability to highlight text either in bold or italic.
Q2. Save the data into a cell on a spreadsheet as it appears in the
textbox
with bold or italic prints
Q3. Populate that cell information into a Bookmark in Word.

Can this be achieved..

Thanks






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Font/Color/Bold/Italic Remain Same dberger16 Excel Discussion (Misc queries) 2 January 21st 09 08:36 PM
Formula to identify character formatting (bold, italic, etc) alphaorionis Excel Worksheet Functions 3 July 1st 07 11:19 PM
Delete rows with bold or italic text MAYDAY[_6_] Excel Programming 3 October 20th 05 11:21 PM
How to apply both Italic & Bold in Header & Footer? Regina Man Excel Discussion (Misc queries) 1 September 26th 05 09:35 AM
Show or hide rows when text is bold or italic Sophisticated Penguin Excel Programming 4 December 1st 04 09:45 AM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"