VBA USERFORM SCREEN SIZE
I tried to fit the vba userform with laptop screen size.But it is not coming properly.Kindly Suggest
See also questions close to this topic
chance color in text from cell with vba excell
hi i want to change some text when saving to worksheet the cel has multiple textbox's values together
when textbox is colored red in vba excell it have to save that textvalue in the cel in font red when it if not red it have to save in black front color
Range("w" & lmaxrows + 1).Value = "S " & TextBox42.Value & " |VP " & TextBox43.Value & " |NP " & TextBox47.Value & " |E " & TextBox48.Value If TextBox42.BackColor = vbRed Then With Range("w" & lmaxrows) d = "S " & TextBox42.Value If Range("w" & lmaxrows).Value > "" Then Replace(Range("w"), d, Range("w")).Font.Color = vbRed Range("w")).Font.Color = vbRed end if end if
i have this for now but it dont work plz help me
VBA - Count at specific cell
I know this is going to be an easy tweak, however I have tried a number of variations and have also been on Google and this forum with little luck.
The code I have so far gives me a row count for column B, with a return value of 225. However I want the count to begin at cell "B17" to return a value of 209. This is because B17 is the beginning of a table within my spreadsheet that will hold a variable amount of data.
The code so far is:
With ActiveSheet LastRow = .Cells(.Rows.Count, "B").END(xlUp).row End With
Thanks in advance
How to delete and create a new excel with same name in VBA
I would like to create a new Workbook with the name 'Land-DE'. If the file already exists in the directory it must delete it automatically before creating a new one. I've tried using the following code but it is not working.
Sub createwb() Workbooks.add Dim FSO Dim path As String Set FSO = CreateObject("Scripting.FileSystemObject") set path = "D:\Job\Land-DE.xlsx" If FSO.FileExists(path) Then FSO.DeleteFile path, True else ActiveWorkbook.SaveAs "D:\Job\Land-DE.xlsX" End If End Sub