+ Reply to Thread
Results 1 to 4 of 4

Hi to all :-)

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    Argel
    MS-Off Ver
    Excel 2013
    Posts
    1

    Hi to all :-)

    Excel it's my "Amigo"

  2. #2
    Registered User
    Join Date
    01-30-2014
    Location
    Argel
    MS-Off Ver
    Excel 2013
    Posts
    1

    Re: Hi to all :-)

    This is to make MayMin.bas file, just create file with next code inside an them import to PERSONAL.XLSM or to any VBA PROJECT.

    Attribute VB_Name = "MayMin"
    Rem Ahnied García Valdés
    Rem Ctrl+Shift+U for Upper-case and Ctrl+Shift+N for Lower-case letter
    Sub Uppercase()
    Attribute Uppercase.VB_ProcData.VB_Invoke_Func = "U\n14"
    Dim SelectArea As Object
    Set SelectArea = Selection
    For i = 1 To SelectArea.Areas.Count
    For j = 1 To SelectArea.Areas(i).Cells.Count
    SelectArea.Areas(i).Cells(j) = UCase(SelectArea.Areas(i).Cells(j))
    Next j
    Next i

    End Sub
    Sub Lowercase()
    Attribute Lowercase.VB_ProcData.VB_Invoke_Func = "N\n14"
    Dim SelectArea As Object
    Set SelectArea = Selection
    For i = 1 To SelectArea.Areas.Count
    For j = 1 To SelectArea.Areas(i).Cells.Count
    SelectArea.Areas(i).Cells(j) = LCase(SelectArea.Areas(i).Cells(j))
    Next j
    Next i
    End Sub

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Hi to all :-)

    Welcome to the forum.

    Can you post that code in the Programming Section and named it that best describe the problem.
    This subforum is for introduction purposes only.(off topics)

    Nice to have you with us.
    Regards,
    Vladimir
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  4. #4
    Registered User
    Join Date
    01-30-2014
    Location
    Argel
    MS-Off Ver
    Excel 2013
    Posts
    1

    Re: Hi to all :-)

    Helow

    I’m apologize, I just wanted to post something to help.
    The code is for change, any text in any excel sheet, from UPER-CASE to lower-case and back from lower-case to UPER-CASE, using the key combination CTRL+SHIFT+U (UPER-CASE) and CTRL+SHIFT+N (LOWER-CASE).

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1