VBA Form - Resize 1st Tab Again To Go Back To Its Original Size?
Sep 29, 2011
I have a form in vba with two tabs. Both the tabs are different sizes.
The first tab is quite large and the 2nd tab is smaller.
When I click the 2nd tab it shrinks the form but then when I click back to the first form it makes it the same size and the 2nd tab and cutting out key info.
Is there anyway I can resize the 1st tab again to go back to its original size?
View 3 Replies
ADVERTISEMENT
Aug 21, 2014
I'm setting up a payroll for several employees in one workbook. I start from the particular employee's worksheet and then I need to go to another sheet where various information is stored and then come back to the original employee's sheet. The current macro works fine if the various information is stored on each employee's worksheet but I can't figure out how to go to another sheet and then come back to my active cell in employee sheet.
[Code] .....
View 14 Replies
View Related
Apr 2, 2009
when i use a macro to add a comment to one of my cells, if i put in too much text the box doesn't resize itself and you can only read part of the comment. how to resize the comment box to the size of the text i put in?
View 2 Replies
View Related
Nov 23, 2006
open the attachment & click the button. I'd like you to please help me in reducing both the height & width of the picture. So that when the button is clicked the pic. overall size will appear smaller.
View 9 Replies
View Related
Nov 29, 2011
I'm trying to make cell values in a range change so they appear blank when a checkbox is checked, and when it is unchecked, I need the original value to appear. I have the following so far:
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then Range("BTS").Value = ""
End Sub
...However I do not know how to change the cells back to the original value before it was made blank.
View 2 Replies
View Related
Jun 26, 2013
I am needing to create a form that exports data (a quote) to an Excel Db (table) and is then able to recall the data back into the form. (the default form in excel does this and I want to copy that.)
Once the data is called back in, I can then export it to another Table to show that the quote has been approved and will be used.
I am having trouble with the VBA coding that copies the inputted quote in Cell C2 (the reference for the quote number) of the "Form" sheet and looks it up in the "Database" sheet. I have tried several variations of code, but nothing works so far.
-SS
Sub RecallQuote()
'
' RecallQuote Macro
'
Sheets("Form").Select
Range("C2").Select 'this is the cell that holds the quote number to look up from the table
[Code] ......
View 2 Replies
View Related
Nov 28, 2013
I am a novice user and not very familiar with Macros or VBA. I took a macro I found on contextures and got it to resize comments that already exist. However, I am trying to get it to also create the comment (with no content) if the comment does not already exist, and then resize it. This is what I have so far:
Code:
Sub ResizeCommentsInSelection()
Dim mycell As Range
Dim myRng As Range
Dim lArea As Long
Set myRng = Selection
[code].....
View 2 Replies
View Related
Apr 26, 2009
I have an Excell 2003 workbook with 6 worksheets and some VBA programmed macros in it.
With a small amount of data the .xls file size is 150k. Then I tested it with a much larger sample of data, which goes into one of the worksheets, resulting size 3MB. Later on I reverted to reading in the original small amount of data but the file size stubbornly sticks to 400k instead of reverting to 150k.
The old data is definitely not there anymore - I used this code to clear it:
View 13 Replies
View Related
Dec 20, 2012
I'm using Excel 2010 and I applied a Data Filter to a simple table. I then messed around with the drop downs in each column, sorting the data by different criteria. After doing this, is there a simple way to get the table to revert back to its original order/form?
View 3 Replies
View Related
Nov 11, 2009
I have a userform, when using the form it has focus, once I click on my "Ok" command button I want to return focus to the workbook while I leave the userform open. I already have the userform open and on top of the workbook.
View 2 Replies
View Related
Mar 13, 2007
MY resolution is 1024X768 , and the form is full size of the screen. i want that in other computers , in 600X800 resolution , the form will be also on over the screen/
View 3 Replies
View Related
Nov 16, 2012
I have several files with form control buttons that automate functions but, on occasion, they get smaller relative to the worksheet they're in. At some point, they become unuasable unless they're manually resized.
View 8 Replies
View Related
Feb 1, 2014
I have a combo Box (Form Control) in my spreadsheet which is basically used as a drop down menu.
How do I change the font size of the text that appears in the box?
View 2 Replies
View Related
Sep 5, 2012
The problem is when I highlight a row with some color the original color of the row is gone, so I tried this code, and again, it's removing the original format and color for the row This is the code from McGimpsey & Associates : Excel : Highlight row with background colors
Code:
PrivateSub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Const cnNUMCOLS AsLong=256
Const cnHIGHLIGHTCOLOR AsLong=36'default lt. yellow
Static rOld As Range
Static nColorIndices(1To cnNUMCOLS)AsLong
Dim i AsLong
IfNot rOld IsNothingThen'Restore color indices
[code].....
How can I retain the range's historical color so that when I deselect the row it reverts properly?
View 4 Replies
View Related
Aug 11, 2012
I have a layout something like the following:
A1
A2
A3
[Code]....
Where each (i.e., A1) represents a location. I have tried to use a coordinate system but this will not work for the back-to-back locations. (Assuming each location is 2 feet wide, For example A1 to C1 is 4 feet apart, not 2 feet (as Euclidean or rectilinear would calculate it as).
Would there be a way to incorporate an if statement for those locations that are back-to-back? As a rectilinear distance calculation would work as long as the locations are not part of the same "block".
Ultimately I am looking to have a matrix which contains all the distances between each location:
A1
A2
A3
B1
[Code].....
View 4 Replies
View Related
Jun 20, 2006
Is there a way to resize the name box, the box directly to the left of the formula bar?
View 2 Replies
View Related
May 9, 2007
I am trying to write a code to resize every second row between the range of A5 and A500 (Starting at A5) to 12.75 but am unable to find a simple loop to do this.
View 3 Replies
View Related
Feb 21, 2014
I trying to out together a small script which performs the following:
-Select cell B7 and offset this by 12 columns and one row
-Resize this by 14 columns, then
-Apply the font format to the selected range from the first to the last row
The code below is what I've put together so far, and although this runs without issue, it's not applying the formatting.
[Code] .......
View 14 Replies
View Related
Jan 11, 2010
I have 3 workbooks, the first one contains the data and the second is the “Table1” containing "Normal records" and the third is the “Table 2” containing only "900 Records". Tables 1 and 2 will be linked to Access…..
Here’s my issue….
From workbook 1, I would like to copy data from certain cells that contain data to Table 1
From workbook 1, I would like to copy data from certain cells that contain 900 service records data to Table 2
In workbook 1, I have identified which information i want to keep by using the following formula,
View 14 Replies
View Related
Sep 8, 2007
I have the following
Cells(c,r) = Range("fa:" & "fa.Offset(0,5)").value
Fa is a code that searches, once it's found something, it then puts that one cell.value into Cells(c,r). it then moves on until the next cell found with the required contence. I need it to put that one cell, and the next 4 columns along side it starting in Cells(r.c)
The problem is, I keep getting a global error. I am sure I have done something like this before, but cannot find it, or remember how i did it.
View 6 Replies
View Related
Jul 20, 2013
stretch" the userform to fit the height and width fo the screen. I dont want to simply change the height and width of the userform, i want the controls within the userform to stretch with the userform so that it looks the same, just fullscreen. this is what ive found by googling:
VB:
With Application
.WindowState = xlMaximized
Zoom = Int(.Width / Me.Width * 100)
Width = .Width
Height = .Height
End With
however, this just stretches it to match the width of my screen, but doestn consider the height, so that if i have a widescreen vs a square screen it will cut off the bottom of my userform. It would be great if there was a zoom type featur that zooms the vertical and horizontal dimensions seperately... more like a stretch than a zoom.
View 2 Replies
View Related
Jun 6, 2014
I need to make rows expand to fit the largest text box within that row. I found the code below online, it works perfectly on the spreadsheet it came on but it doesn't work on my spreadsheet.
Dim cr As Range
Dim ht As Single
Dim mht As Variant
Dim cn As Integer
[Code]....
View 6 Replies
View Related
May 1, 2014
I would like to scale an image to 124% how do I do that
View 1 Replies
View Related
Oct 18, 2008
1.My macro code to insert picture from C:pictures to worksheet in colum B,but the insert pictue are very big. how can it is automatic resize with autofit in the height of the column B when i click the insert button.
2.I need some code for the delete button. if I need to delete some picture,when the delete button is clicked , the input box prompt for key in the picture name to delete. if i key in the pictue name , eg.pictue2 , so the name of pictue2 in the column A and the pictue2 in the column B is deleted.
View 2 Replies
View Related
Apr 29, 2009
Range.Resize to an entire row? I have a range variable:
View 2 Replies
View Related
Sep 9, 2009
i m sending image files via EMail attachment with VBA code. Though the images are 5Mb+ each and when sending 20+ on a 128k upload connection that takes a while. Is there a way that the images can be resized through vba and saved as a new folder. Or send the images to another program and pause the code until the resizing has been done.
View 3 Replies
View Related
Oct 14, 2009
I am trying to print a range that falls just outside of a normal A4 size. Is there a way of scaling this range to fit the page. Withough changing the column sizes before printing(each column is diffrent size). Or will i need to load the column sizes into a array and resize for the print then back to original size from array.
View 2 Replies
View Related
Oct 20, 2005
Macro to CHANGE number of rows “3” to a variable range
(end.xlDown) on the macro below.
Sub GotToRangeResizeCopyPaste()
Application.Goto Reference:="MyRange"
ActiveCell.Resize(3, 10).Select
Selection.Copy
Range("OtherRange").Select
ActiveSheet.Paste
End Sub
View 11 Replies
View Related
Mar 13, 2012
I want to resize a formula array but I am not able to do it.
Here is my code so far :
Thisworkbook.Sheets(2).Cells(3, 1).Resize(lastrowsource - 2, 1).FormulaArray "=IFERROR(INDEX('Sheet1'!$c$1:$c$999999,MATCH(b3&d3,$A$1:$A$999999&B$1:$B$999999,0),1),""Not found!"")"
View 9 Replies
View Related
Mar 25, 2012
I'm trying to resize the data labels in my chart so that the word Institutional appears on 1 line (It's currently on 2 lines) like the pic below:
but clicking the corners of the data label and dragging it does not work for me. I click on the corners and nothing happens. How I can make the data labels bigger without getting the text cut off to the next line?
View 2 Replies
View Related