1. S

    Calculating Time Units - VBA User Form

    I have code that will calculate time elapsed and how many 15 minute units are between the two times entered. It was later decided that an user form may be the more appropriate approach for my audience but I have 0 experience with user forms. I made an attempt but I can't figure out how to make...
  2. D

    VBA ListBox variable/object type

    Hi all, I have a UserForm with a ComboBox and a ListBox on it; their respective names are "ComboBox_Field" and "ListBox_Value". Their list values are currently strings, but might be dates or integers as well. Now, I have a function to count the number of selected items in a ListBox...
  3. C

    Help with copy and paste VBA

    When i click a button i have it copy a string of text to my clip board, and it worked fine in windows 7, but i have seen some info around the internet that windows 10 has made that complicated and i have seen people say i need to use the API to copy text to consistently work in windows 10. For...
  4. D

    Initialize a UserForm with custom name

    Hi, I need to create a UserForm containing a ComboBox initialized with two pre-defined values. The UserForm code looks like this: Private Sub UserForm_Initialize() ComboBox1.AddItem "Value_A" ComboBox1.AddItem "Value_B" End Sub If I run the code, the results are as expected ONLY if the...
  5. M

    UserForm initially displayed and now doesn't - what did I do wrong?

    I am attempting to have a UserForm which contains a set of buttons to allow the users to display different sheets and hide the tabs for neatness. The UserForm should display at the top left of each sheet (i.e. where A1 is). I have used the code from Pearson Software Consulting with a simple...
  6. D

    VBA Userform with inactive workbook

    Hello all, I have an Userform which starts up when Workbook is open, and the workbook gets minimized. Userform is show modeless so other open workbooks could be handled Private Sub Workbook_Open()ActiveWindow.WindowState = xlMinimized Workbooks("New BOM Maker Userform.xlsm").Activate...
  7. S

    Userform Combibox (dropdown) box populating

    Good Morning, I've got a data array, which my userform combibox/dropdown menu references. I have 100 available "slots" for data input in the array, but I don't use all of them. The initialize code (below) works well for the combibox to populate it. However, being as I only use about 20 of...
  8. glfiedler

    Userform in add-in must be clicked before it is "active"

    I have created an add-in that functions perfectly except for one annoying thing. The add-in creates a new workbook by copying the add-in's first sheet. This new workbook is then populated with data from an archived workbook that the add-in has opened. This works well and I can watch the data...
  9. B

    Long, Difficult, Very Specific Problem on VBA Code for User Form Log In for Multiple Users

    I have a very difficult and specific request that I would like a lot of help with please. I have a very large macro-enabled workbook with around 260 sheets. Originally, I used some VBA code so that no matter what sheet the user was on when they saved and closed the document, the next time it was...
  10. C

    VBA to define variable using if then

    I am wanting to have a outlook email address to be set based on the value of Combobox2. What i have doesn't seem to function, and i am sure it is simple but i am a little stuck. any suggestions would be great. What i have so far is: Dim name As String If ComboBox2.Value = "Bill" Then Set...
  11. P

    After transfering data from a userform one sheet becomes hightlighted

    The problem is when i use a userform to transfer data to a worksheet that worksheet becomes highlighted. the problem is this started at row 54 and continues on the rest of worksheet as i add data from the userform this problem didnt happen in the previous 53 rows. What i have to do to get the...
  12. S

    Export/Save images loaded to userform to a specific folder

    Hello, Can I please have your help to create a code that allows me to export image1 and image2 to a folder name that changes based on every new entry. The images will be loaded to the user form by click the image shape in the userform. I would like to export or save the images on the a folder...
  13. D

    Best way to create a searchable drop-down list with auto-complete functionality to cells in a column?

    Hi Folks, I have a time-sheet workbook with two worksheets (ws). In sheet 1 (the time-sheet ws), Column A is "Employee". Time-sheet worksheet. <tbody> Employee Start time Finish time Hours worked Joe Blogs Jane Doe </tbody> I wish to be able to start typing a different...
  14. N

    Excel VBA Date Picker for win64 bit

    Hello, I'm using Microsoft Office 16 in windows 10 / 64bit I'm looking for a solution to have a popup date picker in my userform I'v been searching for a solution long time ago, found a lot of solutions but most of them for 32bit, and some for 64bit but none of them worked correctly Please I...
  15. A

    help code vlookup on userform

    hello i have sheet1 contains data from a2:d10 and userform contains textbox1,2,3,4 i would when i write in textbox2 it shows me the rest data in textbox1,3,4 the textbox1 connect column a textbox2 column b textbox3 column c textbox4 column d with considering column b...
  16. A

    Several issues with userform macro

    Hi Guys, I have a few issues with a userform. It used to work fine but after I made a few changes it stopped working. When you fill out the form it should open 2 emails ans display them before sending them to make sure they have the necessary attachments but it only displays the second email...
  17. S

    Userform Picture and text selection

    Good Morning, I was wondering two things, both interrelated: 1. I have a drop-down box that selects a bunch of info from an array using vlookup formulas and vba coding. Is it possible to have a collection of pictures saved on a sheet in the workbook and then the background of a userform as...
  18. K

    Check if date is Sunday

    Hi Everyone. I have a UserForm where the user must update the Public Holidays (South African) for the year. Basically the user must only change the year and then the date of Easter Friday. All the other dates will auto update in the relevant Table ("tblPPH") In this UserForm, there will be a...
  19. U

    Userform display control

    Using the following code to show/hide Labels and OptionButtons on a Userform UserForm1.Label5.Visible = False UserForm1.OptionButton2.Visible = False They still show, any ideas ?
  20. A

    Drag Picture on Userform

    Is it possible to have a Picture on a UserForm and have its size change with the Form as you drag the bottom right corner ? I have this working on some other platfoms (Access, VB6) but can't seem to manage it in Excel - or the Picture flashes white bars while moving. Any help much appreciated.

Some videos you may like

This Week's Hot Topics