I have the following codes to test Caps Lock whether it is on or off. Instead of showing a msgbox when the Caps Lock is on, I there another way to show comment or other object as well as windows UserForms
View 3 Replies
Would like to set CAPS-LOCK On and Off using VBA. Can someone help please?
View 5 Replies View RelatedHow do you programatically enable the CAPSLOCK key in VBA? I've tried:
Sendkeys "{CAPSLOCK}"
When I run this, Excel's status bar flashes "CAPS" for about 1 second then disappears. It seems to have no impact on the keyboard for case-sensitivity - which is what I'm shooting for.
I have a userform contains a label control .. what I want is showing that label when Caps Lock is on and hide it when Caps Lock is off.
View 14 Replies View RelatedI want to switch on Caps & Number lock on opening an Excel document. I'm using the following code;
View 10 Replies View RelatedDoes anyone have a way to change columns of text entered in all caps to the initial capital letter and the rest of the text in small letters.
As in: JONES to Jones.
Add a column next to the first name. The in that column use the formula
=Proper(A1), A1 being the cell that contains the first name. Then copy that
cell down. Do the same for Last Names. Then keep the cell values, and delete
the original set.
Should be an easier way I think (selecting the entire column and using
conditional formatting) but MS hasn't seen fit to do this yet.
--
John C. Harris, MPA
JCZ Consulting Services, LLC
"Robert Judge" <RobertJudge@discussions.microsoft.com> wrote in message
news:56F8D0DC-3D88-441F-9B47-A5CCDFD133A4@microsoft.com...
>I have an EXCEL worksheet with columns including first name and last name,
>in
> all capital letters:
>
> Column A is JOHN
> Column B is SMITH
>
> How can I change all the names so that, for example, JOHN becomes John and
> SMITH becomes Smith?
I have some vba code that currently copies a status table out of a worksheet, into a temp file for an email. The status table in excel has a column D which can have different status. I want to select everything in the table except rows that are 'Descoped'. Currently my code looks like:
Set rng2 = Sheets("Execution Status").Range("B2:F420")
This picks up everything without looking at the status. I want to change it so it doesn't pick up the rows where Column D contains 'Descoped'.
In pseudo code I would describe it as:
Set rng2 = Sheets("Execution Status").Range("B2:F420") where value in D5:D420 is not equal to 'Descoped'.
I have tried:
Set rng2 = Sheets("Execution Status").Range("B2:F420").Value "Descoped" and nothing gets selected.
I like the proper formula and find it handy, however do you know if there is a formula that would only keep the first letter in the cell at caps and reduce the rest to lower case, ie
A1 = MY DOG IS WHITE
proper(A1) = My Dog Is White
what I want is only first letter caps = My dog is white. I'va had a decent look around but can't find anything that would do this?
It appears that the excel IF statement caps out at eight arguments. Is there a work around for this? I need to enter 29 arguments... Does excel have a CASE or Array function?
Example-works:
=IF((H3="Weight1"),"A",IF((H3="Weight2),"B",IF((H3="Weight3"),"C",IF((H3="Weight4"),"D",IF((H3="Weig ht5"),"E",IF((H3="Weight6),"F",IF((H3="Weight7"),"G",IF((H3="Weight8"),"H",""))))))))
Example-doesn't work:
=IF((H3="Weight1"),"A",IF((H3="Weight2),"B",IF((H3="Weight3"),"C",IF((H3="Weight4"),"D",IF((H3="Weig ht5"),"E",IF((H3="Weight6),"F",IF((H3="Weight7"),"G",IF((H3="Weight8"),"H",IF((H3="Weight9"),"I""")) )))))))
I was handed an Excel Spreadsheet containing a list of names. Within the sheet there are three names (Elizabeth, Amy, and Daniel) that contain upper and lower case letters. The desire is that all names are in CAPS. However, these three names refuse to remain as CAPS when overwritten in the cell. As a note, other names can be typed in those cells and will successfully remain as typed, either U/L case or all CAPS. Another note, if the Replace feature is used, the names remain as Replaced.
View 9 Replies View RelatedI have a column of cells which looks like this:
"JUMPING LAZY brown fox"
I need to put the non capitals in the front as so:
"brown fox JUMPING LAZY"
I have looked in conditional formatting, but do not see a way to change lower case to all caps. Is there a way to do this so that when someone types in a cell it returns all caps instead of leaving it in lower case?
View 9 Replies View RelatedI have a column with names, where i need the 1st letters of the Names to be displayed in CAPS. If its a Single letter also, the same should be displayed in CAPS
View 2 Replies View RelatedIs there any way to format a cell so that text entered will always display in caps?
View 4 Replies View RelatedIn the attachment 1st tab column Q I want it to show no more than the Location Cap (Column M) UNLESS the Current Hourly Rate (Column L) is higher than the Cap.
If the Current Hourly Rate (Column L) is lower than the cap but with the increase from the 2nd tab (Loc Info) makes it greater than the Location Cap (Column M) then I want it to show Location Cap. There were only a few lines that did not work right and i can't figure out why. I have attached one of the lines that were not working right.
Ultimately I want to do the same from 2015 (Column R) and 2016 (Column S) but referencing the previous year.
Attached File : Help2.xlsx
I've currently written the following code to make sure exactly 2 single cell selections are made. But now, I want to extend this code to make sure only cells from rows 5 & 7 are selected and the cells are in the same column.
View 2 Replies View RelatedIs it possible to have this type of case sensitive sorting (first all words beginning with a capital later and then all cells beginning with a lowercase letter):
A
B
C
D
E
F
G
a
b
c
d
e
f
g
how I can format individual cells to put text in caps. I have found how to format the whole worksheet, but I only want certain cells to do it.
View 9 Replies View RelatedI am trying to get a custom date format that looks like:
30MAY07
I can get 30May07 with ddmmmyy but can't seem to find how to get the 3 letter month to display in caps.
Excel 2002 SP3 on WinXP
I have a form that information is entered in. At the end the user can then save the information in a spreadsheet by pressing a command button. The updating to the spreadsheet works, it is the part where the last entry is tested against the info on the form to prevent a duplicate entry that do not work.
I have tested that the program reads the info from the spreadsheet (see the commented lines).
I can attach the whole spreadsheet, but some of the entries on the form are linked to another spreadsheet that make it a bit cumbersome to attach two files.
VB:
Private Sub cmdUpdate_Click()
Dim lRow As Long
Dim ws As Worksheet
Set ws = Worksheets("TonnageInput")
[Code] .....
I am trying to write an Excel formula to test if there is data in pairs of cells and if there is I want to copy the entire record to another Excel spreadsheet. Example: if there is data in row 1, column A and data in row 1, Column C or row 1 column D, then copy this record to another spreadsheet; if there is data in row 1 column B and data in column C or column, then copy this record to another spreadsheet. Since there is no data in row 4, column C or column D, this row would not be copied. Row 1, row 2, row 3, and row 7 would be copied to another spreadsheet. The data can be numeric or alpha numeric.
I tried using the ISBLANK statement and can't seem to get this to work properly.
This code is functional but very redundant and I figured that has to be an easier way to go about this.
View 5 Replies View RelatedI have a program that relies on a remote drive being open and ready. My current tactic (which works perfectly well) is to have a file in the destination drive and ask the date that file was created. If an error occurs I know the destination drive is not ready.
Code:
On Error Resume Next
temp = FileDateTime(destDrive & "xDeletedStuff" & "testFile.txt")
If Err Then
MsgBox "Destination Drive / Folder Not Ready"
Exit Sub
End If
On Error GoTo 0
Idealy I would rather not use the "testFile" I would prefer to just test to see if the folder existed, "destDrive & "xDeletedStuff"
I working on a loop that would find blank cell. These cells have a formula in excel, but if certain conditions are met, the cell is left blank. What property in VBA checks for blank cell? I don't thin it's the "empty" property?
View 9 Replies View RelatedI have to test if todays day is Saturday. Don't know the syntax.
View 3 Replies View RelatedPerforming hypothesis testing on data comprising of hours devoted to patient care per week for practitioners in conventional and alternative medical practices. I have used data analysis -> z-test-two sample for means to perform my calculations.
I would like to know if this is the correct way to perform the hypothesis calculation. See attachment for more details.
Testing For First Letter Of Entry. within an if statement, i'm testing for the first letter of another cell with the function: left(e273,1)= "D". this works well, but i only have a few letters to test for and i'd like to test for not "D", etc. (i.,e, what if the first letter is not D, then do...)...?
View 2 Replies View Relatedscenario testing and coming up with a simple "multiply by" that I can drag across a table.
View 5 Replies View RelatedI have simple data points based on a question that how many people liked product A between 2011 and 2012.
It looks like below
2011 2012
# of Respondents 319 329
% of respondents liking the product 78% 84.5%
The question is: is the increase from 78% to 84.5% statistically significant at either 95% or 99% confidence level. Is it possible to do this basic analysis using Excel?
