Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concantenating Text with | and ' (vertical slash and single qoute)
I have a spread sheet that links with another application. the link is
written as a formula in the cell where the linked value is supposed to appear: =ILX|Q!'RYL.UN-T.LAST' My problem is that I am trying to use VBA to get input from user to replace the RYL and UN and LAST parts of the formula. Everything works except I cannot add the | (vertical slash) and ' (single quote). So my current formula that works is: "=ILXQ!" & TextBox3.Text & "." & TextBox4.Text & "-T,LAST" but I need it to be like: "=ILX|Q!'" & TextBox3.Text & "." & TextBox4.Text & "-T,LAST'" only this last formula does not work (when I try to concantenate it using vba). I will greatly appreciate any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concantenating Text with | and ' (vertical slash and single qoute)
When I ran the code you posted, I could get it to run just fine. Please post
more code so we can see if something else is not working. I used your second line (that you cannot get to work) preceeded by: Cells(1,1).Value = ... And it worked just fine, it even put it into the cell correctly. Have you tried verifying that the textboxes (3 & 4) are indeed being populated? What is the error that you are getting when you run this code? Hope we can help, Jim -- I appreciate any feedback. Please don''t be scared to say that "Yes," I/someone else did answer your question. Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concantenating Text with | and ' (vertical slash and single qo
Well, What Do You Know.... I DOES WORK!
Well now I just feel like the biggest goof either side of the Rockies. Thanks for your help J Sedoff, I had been racking my brains on this for a couple of days. "J Sedoff" wrote: When I ran the code you posted, I could get it to run just fine. Please post more code so we can see if something else is not working. I used your second line (that you cannot get to work) preceeded by: Cells(1,1).Value = ... And it worked just fine, it even put it into the cell correctly. Have you tried verifying that the textboxes (3 & 4) are indeed being populated? What is the error that you are getting when you run this code? Hope we can help, Jim -- I appreciate any feedback. Please don''t be scared to say that "Yes," I/someone else did answer your question. Thank you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concantenating Text with | and ' (vertical slash and single qo
I'm glad I was able to .. uh.. help? I have to say that I do love the easy
fixes! Best of luck, Jim -- I appreciate any feedback. Please don''t be scared to say that "Yes," I/someone else did answer your question. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concantenating non adjacent cells | Excel Discussion (Misc queries) | |||
Search /Filter vertical Numeric pattern (down single column) | Excel Programming | |||
Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
Creating a single vertical array from multiple column arrays | Excel Worksheet Functions | |||
how do I create a single row of vertical text? | Excel Discussion (Misc queries) |