+ Reply to Thread
Results 1 to 7 of 7

Help needed learning basic excel vba

  1. #1
    Forum Contributor excelkeechak's Avatar
    Join Date
    07-21-2008
    Location
    India.
    MS-Off Ver
    2013 /2016
    Posts
    363

    Help needed learning basic excel vba

    I M A NEWBIE TO EXCEL VBA.I HAD SPENT A LOT OF TIME BROWSING THE NET AND READING BOOKS ON THE SUBJECT.BUT I COULD NOT GET THE BASICS OF DEALING WITH CELLS ,RANGES AND LOOPS. I M SEARCHING DAILY AND SPENDING A LOT OF TIME ON THE NET SEARCHING FOR THE APPROPRIATE TUTORIALS. KINDLY ANY BODY HELP ME OUT IN LEARNING THE BASICS OF VBA.

    I M MORE CONCERNED LEARNING LOOPING THROUGH CELLS COZ ITS GIVING ME KICKBACKS WHEN EVER I TRY TO WORK ON CELLS.

    HOPING THE BEST ANSWER FRM ANYBODY
    THANKS IN ADVANCE

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Help needed learning basic excel vba

    Please don't use all upper case in you questions.

    Without specific questions I can only suggest that you search the Forum
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor excelkeechak's Avatar
    Join Date
    07-21-2008
    Location
    India.
    MS-Off Ver
    2013 /2016
    Posts
    363

    Re: Help needed learning basic excel vba

    Yeah, thanks for the faster Reply Mr.Roy.

    The thing is i want to learn how to loop through cells in an excel userform.

    i want to learn looping through form controls like Option buttons.etc

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Help needed learning basic excel vba

    There are no cells in a userform. What exactly do you want to do?

  5. #5
    Forum Contributor excelkeechak's Avatar
    Join Date
    07-21-2008
    Location
    India.
    MS-Off Ver
    2013 /2016
    Posts
    363

    Re: Help needed learning basic excel vba

    I m learning excel vba. My problem is that i m not able to work with cells using loops. i m interested to fiddle around with cells.I want the correct syntax and usage of using cells with all the loops in different situations.

    I want the help regarding the Usage of CELLS in vba.For example i want to display a message box with the data in two columns say for example, In Col A A,b,c,d,e, etc.. and in COL B the values are Apple,Boy,Cat etc.

    I want to display the message box as
    A for Apple
    B for Boy and like wise. its just an example i had given. I hope u got my requirement.

    how can i loop and how can i display it.I also want the answer not for this query but to handle cells in all situations. Hope i had given my problem

    Thanks

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Help needed learning basic excel vba

    You might look at http://www.dummies.com/store/product...764574124.html. I don't know the book, but Walkenbach is a good author.
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Help needed learning basic excel vba

    This is one way
    Please Login or Register  to view this content.

+ 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