Use Application.ScreenUpdating = False
at the begin of macro and
Use Application.ScreenUpdating = True
at the end to improve macro speed
Use Application.ScreenUpdating = True at the end to improve macro speed
Private Sub cmdshowChart_Click()
Dim S, e, cm, inches As Double
S = CDbl(txtStart.Text)
e = CDbl(txtEnd.Text)
cm = S 'initialiser
While cm <= e 'guard
inches = cm / 2.54
txtConversionChart.AddItem (cm & " cms = " & inches & "inches")
'advancer
cm = cm + 1
WendEnd Sub
Save the word as text file after applying font with UTF-8
i have a word file which shows boxes when i opened. However when choosing a particular font, the text is being displayed. I selected all the content of the document with ctr+a and changed the font and save as .txt file with UTF-8.
Everything works fine.
Is there is any macro can do this automatically? Basically applying a font for entire document and save as .txt file with UTF-8?
Any tool or software does this?
When i declare a column as varchar(2) - assume my input is ab - only 2 characters are allowed. When i try to insert one more character it throws error.
When i declare a column as varchar(4) - assume my input is abcd - only 4 characters are allowed. When i try to insert one more character it throws error.
When i declare a column as varchar(255) - however i can able to input abcdabcdabcd...more than 255 characters
I don't understand how many alphabetical small case characters a varchar(255) can hold. if it can hold many...why the same is not applicable for varchar(2) or varchar(4)