modal

  1. Nelson78

    VBA and Excel: scraping data from a table in a modal window

    Hello everybody. I'm scraping data from a site composed by hostile zulpages. I'm doing pretty well performing a good number of tasks. Now the problem is scraping a table in a modal window. https://imgur.com/a/CzHLnID As you can see in the image, the window is opened clicking the red button...
  2. A

    Help Scrolling an IE modal

    First off, I appreciate all of your time in reviewing and potentially responding to my inquiry. I have a webpage that loads a modal that is longer than the page displays requiring me to scroll down to get the second screenshot. I have not been able to programmatically scroll the modal despite...
  3. B

    Can relationships be built in an access web database

    Greetings: Novice here. I am trying to create a database that has a modal form for data entry. When the submit button is pressed I want the modal form to populate a datasheet. The relationship is greyed out and I am not sure how to make this work. Any suggestions????
  4. O

    Modal to Modeless Dialog boxes

    Hi Guys, I don't think this is going to be possible, but there is always no harm in trying! Most Excel custom (in-built) dialog boxes are open as Modal. Is there a way to open these dialog boxes as Modeless? Many thanks
  5. I

    odd Command Button behavior (dead spot)

    I have a vba macro with the following structure: - Open a Form A (vbModeless) - In form, I have tons of controls. Two of them are command buttons. - When I click on button 1 - another form (B) is displayed. This one is Modal. - When I click on button 2 - another form (C) is displayed...
  6. Dave Punky

    Userform over userform (acting as Modal)

    Hi all, I'm having a minor issue and was wondering if anyone had got around this. Basically I've got a Userform (that's modeless) which acts as a primary hub for information. I then have several other Userforms that open from this which ideally I would want to act modally (or really just...
  7. A

    Inspect a range cell by cell

    Hi, I have the following issue, I need to loop throught a range and get 2 things done: 1)the value of the cell 2)select the cell (so I know where I am at all times) this is my first idea for cell in range("a1:a50") cell.select msgbox cell.value next but it doesn'work the selection never...
  8. D

    ShowModal equivalent on mac

    I have an Excel Add-in written in VBA that works in Excel 2003, 2007 and 2010. It contains two forms that are essentially progress windows. The forms have their ShowModal property set to False and receive updates as long-running macro processes continue to execute while the forms remain on the...
  9. PetLahev

    Showing modal Form from Modeless form

    Hi does anybody know why a modal form, that is shown from modeless form, will close the modeless form (parent)? I use a modeless form to allow user continue working on a sheet but when they click on a button on the modeless form a new modal form is displayed, then when the modal form is closed...
  10. O

    Modeless userform doesn't show if called twice from a modal userform (HELP!)

    Hi All, I have a bizarre occurrence! I recently posted a thread here because I had a modeless userform (modeless1) which was activated from a modal userform (modal1) and when used, returned back to modal1 in a loop - the user could then call modeless1 again if more data needs to be processed...
  11. O

    Modeless userform doesn't show if called twice from a modal userform (help!)

    Hi, first post and first attempt at in depth excel programming (so go easy on me!). Here's a simplified version of what's going on for me. I have a modal userform (modal1). If I click on a button the userform is hidden and a modeless userform (modeless1) is shown (modeless1.show False). This...
  12. Jaafar Tribak

    How can I change a Modal Userform from Modal to Modeless at run time ? !

    Hi all, I am wondering if one can force a Modal UserForm to become Modeless after loading the UserForm. Load the Userform as Modal => Click on a CommandButton on the Userform => The Userform now becomes Modeless. Any ideas ? Regards.

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top