I use this ok code to increase the font in the selected cell:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim TargetRange As Range
Dim isect
Set TargetRange = Range("C:D")
Set isect = Intersect(Target, TargetRange)
If Not isect Is Nothing Then
Columns("C:D").Font.Size = 11
Target.Font.Size = 15
Exit Sub
End If
Columns("C:D").Font.Size = 11
End Sub
The problem is when i press ctrl+c to copy a cell content, so once i move the curser to the distenation cell then the copying mode in selected cell disappeared.
It is because when the event is trigered then the copying mode stops. The question is : how to let the copying mode works even when the event is trigered ?
I've created a combo box in excel with the macro recorder. This is the code that came back:
Sub test1() ActiveSheet.DropDowns.Add(1305, 52.5, 242.25, 39).Select With Selection .ListFillRange = "$AW$4:$AW$18" .LinkedCell = "$AX$5" .DropDownLines = 5 .Display3DShading = False End With End Sub
This always results in a default font size of 8 for my list. Can anyone tell me how to modify the code above to change the font size to 14? And how to modify the color of the list.
I have this code as seen below that sends an email.
I would like to change the font size of - mymail.body=
How can I modify this existing code to achieve that.
Code:
Set myOlApp = CreateObject("Outlook.Application") Set mymail = myOlApp.CreateItem(olMailItem) mymail.Subject = strSubject mymail.Body = "WHAT DO YOU PUT INTO A BOX ?" mymail.Display mymail.ReadReceiptRequested = False mymail.attachments.Add "P:SR.xls" mymail.to = "email@email.com" mymail.Send
I have this macro that works perfectly. My boss wanted the subtotal lines within the report to be in a smaller font, so I added lines to the macro to do that. It won't work with those lines in there! It says the reference is not valid on the red line in the code below. The 2 blue sections are the ones I added to change the font size.
Code: 'Add subtotals at the end of each age bucket For i = 10 To LR Step 1 fr = Range("E" & i - 3).End(xlUp).Row If Range("B" & i).Value = "Totals" Then Range("E" & i).Formula = "=SUBTOTAL(9,E" & fr & ":E" & i - 2 & ")" With Range("E" & i & ":R" & i).FillRight
[code].....
Why would the font size make a difference? Is there some other way to change the font size that would work better?
I am trying to set up conditional formatting in cell C4 to change the font to a smaller number based on the value of C4. If C4 = 0 then Font Calibri 16, otherwise Font Calibri 24. However, the font size is not availabe, it is greyed out. Is there another way to accomplish this without using VBA? In the worksheet could I use an if() statement to change the font size?
I'm looking to set up a spreadsheet whereby individuals answer questions and have to format their answer using a particular font, colour, font size and so on. The idea is that I can then compare their answer sheet to a pre completed one using an =IF function and get a total score. The only problem is =if and =exact only lookup cell text/numbers and don't look at how the text is formatted within them.
Sheet 2. A1: Drop down datavalidation list selected from A3, sheet 1.
On sheet 2, a user can select from the list. If a user changes the value in A2, sheet 1, I want the value that is associated and already selected in A1, sheet 2 to automatically update. There is a 1 to many relationship with the concat and the drop down. In that, sheet 2 can have multiple rows with the same value from sheet 1 A3. Is there a way when A3 sheet 1 changes, to search in A:A in sheet two and update the values for those records that match the original value in A3, sheet 1?
1. Copy cells B5 to V-First blank row in Strength Tests worksheet 2. Paste cells into Racks worksheet in cell C5 3. Change font size to 6 4. Sort by Column T descending then by Column C ascending 5. Copy one row (A5-W5 (1Rx23C)) from Racks worksheet 6. Paste row into M1 worksheet in cell D4 7. Print M1 8. Drop down one row on the Racks worksheet 9. Repeat steps 5-8 until there's a blank row.
I have my Excel set up for a default font size of 12 point.
I often download CSV data to insert into spreadsheets. It opens in a new spreadsheet, and it's properly displayed in 12 point size. When i copy and paste it into the ultimate target spreadsheet (which is also set to 12 point size) the pasted data shows up as 10-point and I have to change the font size back to 12-point every time.
Why is this happening and how can I avoid that re-sizing that occurs?
This probably sounds really weird, but does anyone know whether the size of the text in Cell A1 on Sheet 1 can be linked to the size of the text in Cell B2 on Sheet 2? Like, when I change the size of Cell A1's text, is there a way to have the size of Cell B2's text change as well?
I currently have an Excel spreadsheet already created. I have added drop down lists using the Validation>Data feature and can get this to create the drop-down box, but the font is unreadable. If I create a new sheet and create the drop-down list it becomes readable. I can't figure out why the first is unreadable due to its small size. I eventually plan to add formulas to calculate how many yes's or no's in a column, but will address that later. I use Excel 2003.
Is it possible to control the font size in a cell with a sliderBar?. I have a template I use to print labels on cd sleeves and need to change the font a lot. Looking for a fast and easy way,seems like a sliderbar would be easy.
How do you increase the font size of a drop down list in excel apart from zooming in. I have 10 dropdwnbxs each with about 16 items.
Everything works fine but users can not see the contents of each drop down box(fonts are too small). Is there a solution to this? (or just keep zooming in/out). Example i have a drop down box in A2 with source from F2:F17.....etc
I have a simple combo box on my worksheet and the data range is from cells A1:A100 (this is hidden), is there a way to change the font size of the data that populates the combobox? I have tried to re-size the data in my range but this has no effect
I have a drop-down list that displays at about a size 6 (or smaller) font when the worksheet is displayed at 75-100%. I can make it readable by changing the magnification of the sheet to 150-200%, but that takes the rest of the sheet out of view, interferes with functionality, and is just an all-around pain in the butt. How do I format the list to make it display at a readable size?
I have executed this macro from this spreadsheet many times but today, after I execute the macro, the box increased in size. I repositioned it on the page, resized it and re-executed. Now it is decreasing the font size within the button each time I execute. It executed just fine yesterday. I assume it's some setting in excel because I've tried another spreadsheet and am seeing the same result.
I have a created a filter in my workbook. Text for the entire spreadsheet is set to Arial | 12 pt. Font. However, when I select any one drop down list the text therein is shown in a font size that is too small. How can I change the font size to make it more readable?
I'm currently having an issue with Clear All... which sets the font to Tahoma, size 11. Font is okay, but I have my default size set to 10. Everytime I Clear All on even a single cell, the row size increases from 13.50 to 14.25 (from 17 to 20 pixels).
