Search results for query: *

I did find a work around on this and will try to post it later in detail but here is the short of it: In the access db (where you link to from publisher document) add a new text field to the table with the link for the picture in it) Go to publisher and Goto Mailings-Picture (Insert ribbon...

I have publisher 2010 32 bit running on Windows 7 64 bit I inserted a picture file as a link not embedded and saved the publisher document I changed the picture it was linked too and saved it again and then opened publisher 2010 file The linked picture is not updated and in 2010 you then have...

Mike, I just finished up my project and here is the code I used to get the cell value selected to be available globally: Public Function CurrentCell() As String Application.Volatile CurrentCell = ActiveCell.Address End Function Here is how I transfer the cell value...

Mike, that is a good idea as to confining the spell check to only the cell you selected. I am now trying to still get the user form to open to work on text instead of having to mess around with lots of text in a cell. I have forgotten how to get the cell location and sheet name and pass the...

If possible, I would like to see what you did with the mock up and you can send it to me using my forum name sent to an msn account. If you ever need some testing done for a project send it to me (in appreciation of all you do here!)

Mike, Thanks so much for all you have done to help. This forum message may help a lot of others who are searching for a sollution to this. I just found a MS Excel help project that uses a better spell checker in Word and seems to work with really long sentences because it uses word. Here is the...

I just found the commands needed to hid and unhide the address bar: Application.DisplayFormulaBar = False 'Hide address bar Application.DisplayFormulaBar = True 'Unhide address bar

Mike, thanks for the information. I am still unable to find a command in vb that would hide the formula bar. Here are my issues at present: 1. VBA code to hide and unhide the formula bar 2. VBA code to return the sheet name selected and cell address. I have been trying to do this with the...

Mike, the last posting I did may not be a good idea especially if the code has to be rewritten for sheets vs worksheet. I will have to find a way of running the code as modified by yourself from a sheet and return the results to the same cell as it was taken from for the textbox on the user...

Thanks Mike, I will try that code out after running to a medical appointment. If that works, then I will try and finish up my project. I want to look at sheet1 and double click a cell to have it spell checked (this is what I am intending to do). I tried to modify the code so far to work by right...

I just retried copying to notepad and pasting back again and not luck, so the character limit was be the issue. My text in the 2007 sheet cell including spaces etc. was 1399.

I will check out your response. I just did some checking and after the cell text is copied to the userform textbox and then run the code on the hidden sheet I end up with a formula is too long error from the spellchecker. If I copy the hidden sheet text from A1 and paste it into notepad and copy...

I cleaned up the code and made a couple of recommended changes you suggested and now after running the spell check in the code of the hiddent spellcheck sheet, I made one change to a spelled word and finished the process. Then I noticed that the changed spelling to the word corrected did not...

Mike, I have been working on this project all night and just now added your module update and I still get an error. Here is what I am doing: I have a cell F7 that has a lot of medical memo data in it and copy that information to my userform to check spelling and the goal will be to bring the...

Thanks for getting back to me on this. I load text from a cell into the form text box and then click on a check spell control button and I get a runtime error 13 on the following line: If (Application.CheckSpelling(frmEditValues.tbxCellValue.Text) = True) Then The form name is...

I read the question from thread707-1087775 and cannot get the suggestions to work. Here is the code that I have been trying to use (I have coppied an excel cell value to a form and want to spell check it): Private Sub CommandButton2_Click() 'Check HoY Spelling...