Results 1 to 7 of 7

Thread: How to create and place Checkboxes and Textboxes control in MS excel

  1. #1
    Join Date
    May 2011
    Posts
    59

    How to create and place Checkboxes and Textboxes control in MS excel

    I am having the latest MS excel in my computer and that means MS excel 2010 and I want to create a user form I want to create two forms one is to enter the data and another is to select if it is added data and it is in another via a user form. I am keeping the MS excel as the backend and VBA as the front end But in this case I was not able to work on the MS excel I was not knowing that how to make the form and how to place and create Checkboxes and the Textboxes control in the MS excel or in VBA. Please help me in creating the Checkboxes and the Textboxes control. Thanking all in advanced

  2. #2
    Join Date
    Jun 2009
    Posts
    1,518

    Re: How to create and place Checkboxes and Textboxes control in MS excel

    I am a excel programmer and I am knowing that how to add and remove or how to place and create Checkboxes and the Textboxes control by using the VBA you have to first open the visual basic window and then click on the ActiveSheet.Shapes.AddFormControl and after that you have to do some measurements in the xlCheckBox, Left = Cells(1,1). And after that Left + 5, Top = Cells (1, 1) and after that Top, Width: =Cells (1,1). And after that the Column Width * 7, and the Height: =Cells (1, 1).Row Height. This will place and create Checkboxes and the Textboxes control in the MS excel or in VBA.

  3. #3
    Join Date
    Nov 2008
    Posts
    1,514

    Re: How to create and place Checkboxes and Textboxes control in MS excel

    In this case think that you should avoid designing dynamically user forms. You have to first think and then analyze that what is needed and what you want before making the user forms. Firstly you have to design the user forms and then you have to make the user forms so that you will get the idea that where will the checkbox and the textbox will come in this place. Then you have to use the frames, tab strips, and multipage and then you have to make some of the elements visible and invisible. I hope that this will help you.

  4. #4
    Join Date
    Mar 2009
    Posts
    1,360

    Re: How to create and place Checkboxes and Textboxes control in MS excel

    From the discussion going on I think that you can also make the design dynamically the only thing you have to do is to keep the coding of the user form as simple, easy and as fast as possible this is only to your benefit that means the user benefits. In this case you are trying to learn the VBA, so in the dynamically designing is as qualified and as “multi-advanced” for the VBA that means visual basic.

  5. #5
    Join Date
    Nov 2008
    Posts
    1,259

    Re: How to create and place Checkboxes and Textboxes control in MS excel

    I would like to recommend you that are you referring to the main user forms? And how are you trying to open or need to open the VB Editor and it is in (ALT + F11) and then you have to insert it into the menu click on the user forms. So in this case there is the toolbox that is having the most common controls on the VB editor. You have to just use the Application.ScreenUpdating = False and then you have to write the code in these two statements.

  6. #6
    Join Date
    Nov 2008
    Posts
    1,185

    Re: How to create and place Checkboxes and Textboxes control in MS excel

    You have to make the form and from the window that you have selected you have to just double click and then click on the checkbox and the controls which is inside the toolbox. However in the toolbox window you have to check the box icon image and then it may be located in the different location which is located inside the toolbox of the window. You have to make the checkbox that should be selected and then you have to press the F4 key which is located on the keyboard.

  7. #7
    Join Date
    Nov 2008
    Posts
    1,221

    Re: How to create and place Checkboxes and Textboxes control in MS excel

    If you are thinking of making something sound when you click on the checkbox you have to just click on the sound checkbox and then a check mark will appear which is inside the sound check box. And after that you have to click on the sound checkbox and then click on the sound checkbox in several more times and after that you have to disappear from the sound check box. Then the checkbox will sound something when it has been clicked.

Similar Threads

  1. Create a user control form in Excel 2010
    By --MasseySian-- in forum Software Development
    Replies: 3
    Last Post: 06-09-2012, 07:03 PM
  2. It is possible to get value in place of error in Excel Cell
    By Iyyappan in forum MS Office Support
    Replies: 7
    Last Post: 21-02-2012, 07:47 PM
  3. Replies: 3
    Last Post: 11-01-2012, 11:13 AM
  4. How to create .Net custom checkboxes for listview
    By Rover in forum Software Development
    Replies: 2
    Last Post: 11-06-2009, 09:40 AM
  5. How to set the maxlength of the textboxes dynamically
    By Sophia in forum Software Development
    Replies: 3
    Last Post: 18-03-2009, 12:00 AM

Tags for this Thread

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
  •  
Page generated in 1,711,658,460.24003 seconds with 17 queries