Set Initial Userform Font Size Through Properties Window Instead Of Code
Feb 8, 2014Instead of coding it (like below), can you set it in the properties window for labels, buttons.. etc.
[Code] ....
ADVERTISEMENT
Tab Key Ignoring Userform Properties And Some Code Being Ignored
Jul 31, 2012I have a userform with multiple text boxes and combo boxes. Firstly, the Tab Key Behavior setting for all of these boxes is set to false, and so is the Multiline setting, which should make the tab key always move focus to the next object in the Tab Order, but sometimes the tab key will ignore these settings and enter a tab in a text box instead of moving the focus to the next text box.
secondly, I have some code which should run for key presses in these text boxes to only let you enter certain characters in them. Whenever the tab key problem above occurs, this code seems to stop working and lets you enter any character you want.
Comparing Two Cells Based On Text, Font, Colour, Font Size Etc
Jun 3, 2006I'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.
View 9 Replies View RelatedManaged To Lose The Properties Window Altogether
Oct 20, 2009I have been playing around with my vb editor and i have managed to lose my properties window and now can't get it back.
I was playing around with the dockable option to see what it did and somehow i have managed to lose the properties window altogether. If i go to the view menu in the vb editor and choose properties window then nothing happens.
Rename Macro In Properties Window Loses Shortcut
Dec 2, 2008I recorded one that does a very simple task, converts formulas to values. I saved it in my personal workbook, all is well. I noticed that excel names them Module1, Module2 etc. I thought it would be better to name them, so in the properties window next to "name" i changed Module1 to ConvertFormulas.
However, when i go to a worksheet, the keyboard shortcut no longer works. Reverting back to the old name Module1 solves this. Clicking Tools -> Macro -> Macros, selecting ConvertFormulas and then Options and modifying the shortcut.
Display Font Properties
Nov 29, 2006I have searched the forums to find if there is a method to specify font properties ( i.e. size, bold, italic etc. ) in the prompt in a message box but cannot find anything remotely like it.
View 3 Replies View RelatedText Box Properties/font Color
Nov 12, 2009I have text boxes in excel that hold text (obviously) over a period of several days. It gets updated daily, so I want to change the font color for the new text that is added daily rather than all the text. Is there a way to do this?
Also, is there a way to get the verticl scorll bar to always show on the right hand side of the text box? The way it is now, I have to click once or twice in the text box before it shows up. I would like the person reading it to automatically know that there is text not presently in view so they know to scroll down for more information.
Properties :: Difference In Size
Jul 8, 2007In the properties in one of my wb's the Size measures to 1,40 MB, but the Size on disk only measure 408 KB. If I make a copy of the same wb, the copy displays 1, 40 on both.
Why do I have a different size on the original?
Set Window Size With VBA.
Feb 1, 2010I'm looking for a way to use VBA to set the window size upon opening the workbook. When the document opens, there should be two windows, each taking up half the screen and each on a particular tab.
Currently, if I save the workbook with the window settings I want, when I open it, both windows are maximized. When I hit the restore button, they go back the settings with which they were saved, which is what I want it to look like as soon as it's opened. Also, a bonus would be for the code to determine the screen size, so it can fill the screen no matter what monitor/computer it's opened on.
Window Size And Position
Mar 2, 2007I am having difficulty locating / composing a script that will set the Main Excel window size? Even better if I could find a way to set the size and position on screen..
View 2 Replies View RelatedHow To Size App. Window To Fit Cells? (not Zoom)
Oct 16, 2009This "smells" like a simple question, but I've had no luck finding a way to [programmatically] adjust the App.Window to fit around some cells.
I've found "Application.Goto", also the Application.Width/Height setting. The App.Width setting is pixel based, so if there's an easy way to know a cell's pixel-location, that'll work too!
Set Window Size Based On Screen Resolution
Mar 5, 2008I have an Excel based application that needs to run with a screen resolution of 1024*768 in order to display correctly. Is it possible to use VBA to detect the users screen resolution. Then: If the screen resolution is not set to 1024*768 then resize Excel's main window to run at that width and height?
View 2 Replies View RelatedExcel 2007 :: Control Positioning And Size Of Window?
Mar 13, 2012My set up office 2007 win xp pro ie 8 I am using the code below to retrieve web pages etc it works fine, however it display in differ areas of the screen, so I was wondering if there is a way to control the positioning and the size of the window?
Code:
Set EXP = CreateObject("InternetExplorer.application")
EXP.Visible = True
EXP.Navigate (aurl)
[Code]....
Completing Footer From Initial Userform
Oct 21, 2009We currently use Excel to make reports of data obtained in field surveys. General data is repetitive throughout report. We have a title page, general particulars (GP) page, table of contents then data table pages. Each data page has info from general particulars page. i.e project name, date, inspector etc. Right now some cells of data table pagess have formulars pointing to applicble cells on GP page.
Presently I am designing a userform to input title and GP page data. So far OK.
Question: Can I take input on userform and add to footer. Info to be added after or inserted within text already there? i.e. Surveyors Name: ?(left footer) something center and something right. What type of code needs to be added and where do I place it .
Change Size Of Tab Font
May 7, 2009Somehow my tab names (in 2003) have a very small font size. How do I return the size to normal?
View 5 Replies View RelatedInconsistent Font Size?
Jun 10, 2013I 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?
Linking Font Size Changes
Jan 13, 2009This 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?
View 8 Replies View RelatedDrop-down Box Font Size
Mar 18, 2009I 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.
View 9 Replies View RelatedSliderBar To Control Font Size?
Jan 11, 2013Is 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.
View 2 Replies View RelatedHow To Adjust The Font Size In A Comment
Oct 26, 2013Is there a way to adjust the font size in a comment. The default seems way to small. All thoughts on the subject .
View 4 Replies View RelatedConditional Formatting Font Size?
Nov 24, 2013I want to change Font Size ,when Conditional formatting is used in a range.
I know , it is not possible with conditional formatting basic application.
I need a macro code, if possible to do it.
Drop Down List Font Size
Jul 28, 2007How 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
How can i increse the font size?
Worksheet Label Font Size
Mar 19, 2008whats the correct syntax for Font Size as a Label property? I am attempting to change the font size of all Labels on a particular sheet via vb
View 9 Replies View RelatedChnage Font Size In Combo Box
Jul 15, 2008I 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
Font Size In A Drop-down List
May 16, 2006I 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?
View 9 Replies View RelatedChange Font Size Of Combo Box
Jul 18, 2007I'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.
Capture Changes To Userform Selections When Compared To Initial Inputs
Jul 18, 2014I'm trying to capture if any changes are made to a UserForms selections.
I initially load all the data from the database when the first user form is initialized, see code below
[Code]....
Once I have selected the corresponing record from the combobox , in this case Planning Number, then select the command button which runs the code below
[Code] .....
Now the user form frmProcessEngineeringTemp is opened, it now populates all the comboboxes, textboxes and option buttons in this form based on the planning number choosen from initial user form
[Code] ....
Once the user has finished with the user form the information from the form is passed to a worksheet via a command button. If changes to the user form selections were made i need to capture what has changed (if anything), from what was initially loaded into the second user form (frmProcessEngineeringTemp).
I have seen numerous posts from various sites that discuss Change and Exit events from a Class module and many instances where each combobox, textbox and option button is hard coded to capture changes.
Being that I have captured my initial inputs from the database thru the myVar 1 thru 40, can this be put into a string array and the current inputs/selections in the frmProcessEngineeringTemp put into a second array then compare 1 to another looking for difference, then output the differences to a worksheet for tracking purposes. At the same time if changes were indeed made i would increment the Revison record by 1.
Button Text Font Size Changes When Execute It?
Feb 22, 2013I 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.
View 1 Replies View RelatedFont Size In Data Validation Dropdown
Dec 11, 2013Do we have control over the font size in a drop down list created using data validation?
Mine looks like this and I would like to make it more readable by increasing the font size.
data.png
Changing The Font Size In A Filter Drop Down.
Dec 12, 2008I 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?
View 2 Replies View Related