1. M

    use excel while user form open

    I ma trying to set my project so that when my userform is open, I can still select and edit cells. I have tried setting the model to false and using vbmodeless but when I do that the form just blinks and goes away. Any ideas?
  2. W

    UserForm visibility and positioning

    Hello, I have a workbook that opens a userform as (vbModeless) on open and hides the window. Private Sub Workbook_open() Windows("Test").Visible = False Welcome.Show (vbModeless) End Sub The problem i am encountering is that this works only when there are other workbooks opened. If i open it...
  3. P

    Turning vbmodeless on/off for userform

    Hi everyone! I have a userform that I set up with multiple tabs. On one of these tabs, I'd like to be able to reference my userform and scroll simultaneously in my workbook. To achieve this, I know that I have to go into vbmodeless. The problem I'm running into is that one of my other tabs...
  4. P

    Is it possible to loop a userform more than once and disabling certain controls on the second loop

    Sub splitLot()<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;"> i = 0 ansSplit = 0 ans = MsgBox("Is this a split Lot?", vbQuestion + vbYesNo, "Split Lot") If ans = vbNo Then frmPackageYield.Show...
  5. R

    Class Module Triggered by multiple Target.Cell(1).Addresses

    Good day, I have a dashboard on a worksheet that has 50-60 numbers, when you click on any of those numbers a 30-day trend on a userform appears. In my excel vba naivety I inserted 50-60 userforms all with identical code to form the graph. Everything works but boy, what a waste! I have 50-60...
  6. R

    Show Activecell.value when in vbmodeless?

    I have a userform which contains a text box which is used for data entry purposes. The form is always open (i.e. running in vbmodeless) and I am trying to get the text box to display the 'active cell value' (using Text = ActiveCell.Value), However, whenever I move the cursor to a new cell, the...
  7. B


    i have a sequence of userforms used to input various codes into field. That all work great and go from flawlessly, until lately. I added vbmodeless to make cells selectable on one of the forms (everything still worked great. I then added a hyperlink to that same userform (opens up a different...
  8. T

    Modeless Userform using .Show vbModeless started triggering Type Mismatch Error 13

    Hello all, Thanks in advance for any suggestions! A little background: I've been tinkering with VBA for 3-4 years now starting with VBA for Dummies, moving on to Mr Walkenbach's Excel 2007:Power Programming with VBA, and have just recently gotten into Professional Excel Development: The...
  9. pedie

    vbModeless does not work why? Pls help!

    <TABLE style="WIDTH: 539pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=719 border=0><COLGROUP><COL style="WIDTH: 539pt; mso-width-source: userset; mso-width-alt: 26294" width=719><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8...
  10. T

    Editing Spreadsheet while UserForm open

    Hi All, I'm a newbie at excel VBA and I am attemtpting to use a UserForm (with hidden excel) to gather data from a client and give the client a button option to view/edit their excel spreadsheet data. I tried researching the web for solutions to my problem and found info on vbmodeless...

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