loop through controls

  1. F

    Creating a collection or array of CommandButtons

    Hello fellows, this is my first post so even though I read the recommendations I am sorry if I make any posting mistakes. I was assigned to optimize a very old Excel 2003 / VBA file. This is a huge file with literally thousands of controls (Labels, Textboxes, ListBoxes, CommandButtons, etc). It...
  2. S

    Looping a macro to build a report

    OK, forgive me for being overly verbose here. I will try and keep this brief but want to include all the info anybody out there with the right knowledge might need to help solve my problem; as such I am going to explain my issue as I would to a five year old - as much for my own sake as for...
  3. L

    Setfocus is not working after a looping through the textbox

    I have an "Input data" form and all I'd like to do was to add a code so when the user press the button Ok it'd check each texbox and if it's empty show a error message and setfocus back to the empty textbox.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...

Some videos you may like

This Week's Hot Topics