The field is a concatenation of three other fields and only the first of three parts should be boldfaced -- the second and third part should be normal faced.
Is there an easy way to do this in excel 2007? Right now, the formula is:
=CONCATENATE(UPPER(TRIM('Raw Data'!H26)),CHAR(10), TRIM('Raw Data'!G26)," [",TRIM('Raw Data'!J26),"]")
and the part in red, is to appear boldfaced.
I am attempting to merge a scroll bar and an activeX text box. I currently have a horizontal scroll bar that links to a cell with values from 1-20, A dynamic label in the adjacent cell changes when the scroll bar moves. I need the label to be inside the scroll bar track/tray. I was told an activeX text box would do the trick. However, i am new to VBA and activeX text boxes any code or solution to this problem. Conditions:
The slider and the track should overlay the text box label
The track should be transparent but on top of the label
The label should be a perfect fit to the slider's tray
Here is a reference to the scroll bar labels. I have posted an example file of what i am attempting to achieve.
I am working on a financial tracking sheet for somebody in my organization. The totals have to be entered as number of bills, but he wants to read it afterword as $ amount. So is there a way to type in the number of bills in a cell (ie, 15) but have the $ amount (ie, $300.00) show up in the same cell when he hits enter or tab? This is my least favorite solution (assuming it is even possible), but it is what he is asking for. I feel like I just need to know that it won't work before he agrees to try something else.
View 6 Replies View RelatedMy vlookup works.
My IF(ISNA works.
Now I just need to incorporate a formula for if is blank. Not sure where to incorporate it or how.
=IF(ISNA(VLOOKUP(F2,Contacts!H:J,3,FALSE)),"Unknown",VLOOKUP(F2,Contacts!H:J,3,FALSE))
I need to calculate the absolute week and have found a formula to do so. Is there a way to embed/execute this in VBA?
TRUNC(((StartDate-DATE(YEAR(StartDate),1,0))+6)/7) where StartDate is the date which you are trying to find the corresponding week number (for example Now().
I recieved on my last thread (link below), the code provided worked fine.
Previous thread I submitted
I now have a problem with the .value attribute. When comparing Excel finds two cells unequal in '.value' then writes '.values' in changes sheet. When using =A1=B1 the result is TRUE. I don't want equal valued cells to be picked up how can I stop this? (Macro code included in previous thread if needed)
I would like to attribute a number to each digits 1 in position.
 IJKLMNOPQRSTUVWXYZAAABACADAEAF1Â
12345678910Â Â Â Â Â Â Â Â Â Â Â Â Â 2Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 3Â Â Â Â Â Â Â Â Â Â Â Â 4Â 0111110010Â Â 234569Â Â Â Â Â 5Â 1110010000Â Â 1236Â Â Â Â Â Â Â 6Â 1010010110Â Â 13689Â Â Â Â Â Â 7Â
my problem involves displaying rows that meet certain ‘criteria’, on a separate worksheet, in real time. The criteria will be determined by a selection made from a dropdown list in the row in question.
ILLUSTRATION: Let us say (for example) that I am dealing with a worksheet for MEN’S DATA. Each man’s data will be on a separate row. On each row, one of the cells has a dropdown list having 2 options, SHORT and TALL. I have a separate report worksheet for TALL men. I mean, I want every row for which I select the TALL option, to be copied to my TALL report worksheet. I want the selection of the TALL option to be a kind of trigger that promptly copies the row to the TALL worksheet, once I make the selection from the dropdown list.
I have a conversion chart of decimals to fractions I made in Excel. I want to copy and paste as an image so I can shrink it to fit at the top with the frozen headings.
I tried to take a picture of it on the monitor, but the photo captures the screen fuzzy pixels.
I tried to copy and paste but could not find where I could paste as a special attribute. Or a picture on the internet with the decimal first and the fraction second in 1/16ths
I want to show which rows of data have been changed by incrementing a revision attribute. For example, if a user changes the contents of a cell anywhere between rows 2 and 13 and col 1 and 9 then the revision attribute in col 10 would increment from 1 to 2 (for the affected row). If another change affects the same row then the rev attribute would increment to 3, and so forth. I don't care which cell was changed only that something on that row was touched.
I thought the CHANGE event was a dead ringer for triggering some VBA code to control this but, since part of the change event code writes the revision value, this triggers another CHANGE event causing an endless loop until something (??) kicks in and stops it after 220 iterations. Is there a way to inhibit the change event just prior to updating the cell containing the version attribute?
Rather than post the code here I have submitted the workbook that includes the whole setup and code. I should also mention I looked at all the other worksheet events and I do not see any "triggers" that would fire each time a cell content is changed. As a side note, is there a way to step into the code of a change event? F8 does nothing.
How do I embed a pdf file into a worksheet. I've got the following code so far:
ActiveSheet. OLEObjects.Add(classtype:="AcroExch.Document.7", link:=True, DisplayAsIcon:=False).Activate
The code works but it doesn't allow me to specify the filename (i.e. C: est.pdf)
I have a need to embed a wav file into a workbook. This is fairly simple to do through the insert>>object>>create from file, but I see no way to do this through VBA. I want the entire process to be simple so the user just has to click a button, pick their file from explorer, then play the sound file through the little speaker icon that is generally created.
In the end the one sheet (filename.xls) is the only thing sent through email and it must contain the wav embedded inside without using the insert>>object>>create from file route.
I am creating a large excel file with multiple tabs and I need one of the tabs to contain a PDF. I have tried going to insert - object - browse - found the PDF file but it imports very blurry and it's quite hard to read. I tried inserting the object/PDF as a "link to file" and/or "display as icon" and all that essentially does is insert a shortcut to the PDF so that only works if you're on the same computer you used to create the link. I need to be able to send this file to another computer and be able to access the PDF somehow. Am I going to have to buy Adobe's ability to convert PDFs to .xls?
View 3 Replies View RelatedI am trying to show the select file window, choose a pdf, and insert it into a new sheet. i'm using this code:
[Code] .......
I am receiving an error: Run-time error: 1004 Cannot insert object.
why there is no option for adding a picture manually to the comment of a cell? when editing a comment the Insert picture from file from the Insert menu is disabled ! (Office XP)
and can you please edit the code so the Width and Height of the comment box is set exactly to the dimensions of the picture? (that is how to get the exact width and height of the picture being inserted from code in excel ?)
I've already nested INDEX and MATCH sucesfully
I wish to embed/nest (I'm not sure what the difference/ correct syntax is)
These Funtions:
1. "=INDEX($H$4:$H$9,MATCH(G14,$G$4:$G$9,0))"
2, =HLOOKUP(Arg!D10,Arg!$D$10:$DA$50,5,FALSE)
The HLOOKUP returns a text value that the Index and Match convert into a number. I wish this to be done in one cell - is this possible?
I'm using INDEX with MATCH because HLOOKUP can return a 'not applicable' that equals '6' this need to be discounted in my results but that is a digression FYI.
I have an Excel spreadsheet with Harvey's Balls font and need to get the file distributed amongst coworkers. Is there a way to embed the font into the spreadsheet so they don't have to install the font?
View 9 Replies View Relatedi have a sheet that autogenerates a .csv file and uploads it into a webform. In order to do this I have to open an Internet Explorer window go to webpage and use the sendkye function, my code looks like this:
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate "http://uploadsite/upload.form"
'Check connection til web loop!
Do
If ie.ReadyState = 4 Then
ie.Visible = False
Exit Do
Else
DoEvents
End If
Loop
if I instead could EMBED the webbrowser into my sheet and then go to the upload site and upload the file directly from the sheet. I have some basic vba skills, but I have never worked with the embedded objects.
I just learned how to do an Indirect.
So that i can make many pages without having to go through and change everything.
I want have excel search for a name contained in A1 in a table (so i use vlookup).
then but i want be able to change the sheet name easily.
so what i need is something like this:
=VLookup(A1,(INDIRECT("'" & B2 & "'!")),$b$6:$S$23,2,)
this does not work.
But i want the sheet name to be the thing INDIRECT looks up, while the name in A1 is the thing that the VLookup is trying to find.
I am trying to embed part of a webpage into my worksheet. Specifically, I want to include a form from a web-site that allows me to enter a flight number. I then want the results to pop-up in a new web-window.
So, I want the search box (or a section of the webpage) to appear in my excel worksheet so that I don't have to always open IE when searching for data.
[url]
That's the web page.
I have a file with two sheets - Main and Reference. The file has a macro that when used from Main sheet displays some data (images to be specific) from the Reference sheet. The main sheet is of a specific format and has some buttons to call the macro.
I want to have the capability to create any number of main sheets of the same format. I know this can be done by saving the Main sheet as a template and right clicking on a sheet and clicking 'Insert..'. But that would require the template to be stored in the excel start file on the local computer.
I want to know if there is any way the worksheet template can be stored within an excel file, so that if the file is sent to people on a different computer, the user can easily add more worksheets using the template?
I've just written up an SOP for a reconciliation process. Part of it requires the reader to use some Excel UDFs that I've created. Rather than having someone look for the UDF file on the network, I tried to embed it as an Excel Worksheet Icon within my procedure document. However, when I double-click the icon to launch the add-in, I get the following error message:
"Microsoft Word can't start the application required to open this object. An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now?" This does not happen when I embed a regular Excel workbook, or even a template.
I have a need to embed a wav file into a workbook. This is fairly simple to do through the insert>>object>>create from file, but I see no way to do this through VBA. I want the entire process to be simple so the user just has to click a button, pick their file from explorer, then play the sound file through the little speaker icon that is generally created. In the end the one sheet (filename.xls) is the only thing sent through email and it must contain the wav embedded inside without using the insert>>object>>create from file route.
View 3 Replies View RelatedI am not sure whether "embedding" is the right word. Please have a look at this excel file and tell me how to make such a file? .....
View 7 Replies View RelatedHow do you embed a flash file into excel 2003?
And is it userfriendly? For users to use the excel file, they must have flash software installed right?
0 01
0 02
0 03
1 03
0 05
2 06
0 07
in column 2, something may have multiple numbers, but it must have something in column 1 that is equal to 0.
ex. everything above is ok except the 2-06 because it needs a cooresponding 0-06. I need some way to flag these so that i know when there is something in column 2 without a cooresponding 0 in column 1
I have a named range called ReportMonth and I want to embed it into this Table reference to make the number of columns that are summed dynamic:
=SUM(tblFcastTemplate[@[Column1]:[Column28]])
I tried ="SUM(tblFcastTemplate[@[Column"&(ReportMonth+1)&"]:[Column28]])"
I am making one project in excel where I want to add time zone converter Or time zone search in engine in excel for that purpose I have create one portable software for time conversion but I am unable to add or insert or embed it in excel as it is an exe file.
I have attached one winzip file that is carrying Age Calculator in it so that you can have a brief understanding about how does the portable software looks like, age calculator is a portable software as it does not need installation & it works as we run it. I am also attaching excel demo file with it by the name ""time zone", its rough simulacrum of my original project file.
Attached Files
Age_Calculator_v2.zip‎
time zone.xlsx‎
I've done this before in Excel 2003 but I can't seem to do it in Excel 2007 because the control isn't there in the additional controls list.
In Excel 2003 it was called Microsoft Office Spreadsheet 11.0 and when ticked gave an extra item on the control toolbox which allow you to draw an excel spreadsheet control into a userform.
It's not there in the VBE of Excel 2007 - How to do it in this version?
Screenshots of the additional controls screen in both versions: [URL]... [URL]....
I am trying to embed a picture into a worksheet, hide the picture, then call it up later when a macro runs. I know how to insert a picure using a macro, but I want to embed the picture so that I can take the file with me that includes the picture and be able to call the picuture in my macro. Right now, the picture is on my hard drive and the picture will not load if I take the file to a different computer and run the macro.
View 4 Replies View Related