userform

  1. S

    A convenient way to batch rename ( not caption ) multiple command buttons on Userform ?

    Hi, I am creating an Userform with several command buttons on it. Is there a way to batch rename them as : cbButton1 cbButton2 cbButton3 cbButton4 cbButton5 … ? Note: I hope to give new names to them. not to change their captions. The way I am using now, is simply click on them 1-by-1, and...
  2. S

    Populate Outlook Userform Listbox From Excel Data Table

    Hi Guys, I know how to populate a Userform Listbox from within excel, but I want to create a listbox in Outlook to be populated from data in the first column of an Excel table. At the moment I have this from within Excel: Me.ListBox1.List =...
  3. Z

    Multipage hide and unhide VBA

    https://1drv.ms/x/s!AiCZb_GZ2FZegdwGDeVB_yPLnEh0Jg?e=XcDm5Q I am trying to figure out how to take the items checked on a treeview and have them match the caption of a tab on a multipage userform. In the attached woorkbook below is a moch-up of what i have in my project. The criteria userform...
  4. A

    userform combobox - autocomplete with drop down box

    has anybody got a snippet of code to make a combobox auto complete? as the user types in a name into the cbo, i would like them to be able to select from a list that drops down below the combobox.
  5. A

    userform - user must enter name to begin

    Hi, how do i set up a userform to make users enter their name before they can proceed? I don't want to use an inputbox before the form is called as the form is meant to help them save time while answering telephone calls. Currently, their is just a text box for them to input their name but most...
  6. S

    printing userform landscape and on a4

    Hello all I want to print my userform on a4 in landscape. i have searched the web for answers, have found code also, but it just does not work for me. i cant really pull the data from the userform to a sheet either, well not easily, i have certian layout and tickboxes etc the code i have...
  7. B

    Keep userform open when closing other workbooks

    Hi all, I have a userform that opens automatically and hides the workbook when I open the file. It all works perfect - and I have it as vbModeless in order that I can use excel for other things. Problem is, when I close the other workbooks, it also closes the userform and workbook that I want...
  8. K

    VBA for Networkdays

    Hi Everyone. I'm still busy with a workbook for our weekly timesheets. I have created a UserForm for the user to fill in everyday. This information will then be sent to the relevant day in the spreadsheet. On top of the UserForm the day of the week as well as the date is displayed. I got the...
  9. Z

    VBA to change to a different sheet with a command button

    How can I change sheets based on a userform button. If I have a command button on sheet 1 that when it's clicked a userform pops up. But I also want to automatically change sheets to the current day. So say on sheet 1 there's a command button for Monday, Tuesday, Wednesday, Thursday, Friday...
  10. M

    Userform - If value is not found then displays a MsgBox

    Hi - I was hoping you could help me solve the following. With the following code I can get a list of values from a Table and displayed on an UserForm; however, I would like to have a msgbox when the value is not found...
  11. J

    Userform dependent combo boxes

    Have the following code to try that attempts to allow you to use the drop down in a userform which is dependent on the other. It is setup with an advanced filter in the spreadsheet. The problem I am encountering is that nothing shows in the dropdown box (combo box1), any ideas? Thanks. Private...
  12. N

    Lock all the controls in a userform

    Hello, I have a userform with many Textboxes, Labels, CommandButtons.... I need to lock all the controls when the userform Initializes Instead of locking each control separate, I found this code on google that works well if the userform doesn't contain any label, else if there is any label...
  13. G

    Help with Shape scroll or ******* show last empty row

    Hi everyone, I have a shape on a worksheet that when clicked opens a userform to add data, what i would like to do is add to my exsisting code so that when the shape is clicked it not only opens the userform it also scroll the worksheet to the next empty row. Below is my code to call the...
  14. K

    Timesheets and Userform

    Hi All, I built our weekly/daily time sheets some years ago in Excel using mostly formulas to do the calculations. This worked great, but since I started to learn more about vba and userforms I am busy streamlining it to use userform inputs and vba to send the information to the relevant...
  15. I

    Show userform based on cell value

    Currently not at my pc but I would like a userform to only be shown if a specific cell is empty. Would this be correct ? Please advise. If Cell (“B1”) = “” Then Userform1.Show Else Exit sub
  16. M

    Using With...End statement to set fields for two userforms

    Hello, I am a VBA neophyte learning on the job. I have two userforms that I am programming for a spreadsheet. Each user form uses many of the same fields, and so in the code for each userform I have to set the fields up in the same way, i.e. below txtTodayDate.Text = Format(Now()...
  17. I

    Userform to worksheet code advice

    Morning, I have a simple userform which i will select a Month & Year from the drop down box & when i press the command button it will place the selected values into there respective cells. I wish the userform to appear when i open the worksheet BUT only if the cell in question is empty. Should...
  18. N

    How to Add Date Picker To VBA UserForm

    Hello, I have a userform and looking for a way to add a popup calendar to insert a date in a textbox, I searched google and found the way below, I followed it step by step, but it didn't work, https://chandoo.org/wp/pop-up-calendar-excel-vba/ Do you have any way to activate it? I have...
  19. I

    Custom MsgBox. Buttons

    Evening, I’m looking for a msgbox but with buttons as 1 & 2. Is there a way to do this without it being a userform. Thanks
  20. P

    Copy cell value from a different workbook into a textbox in a userform

    Hi, good afternoon, I have a userform with TextBox310 where I want the textbox to show the info from another workbook for example the work book is located in 'G:INDAY.xlsm ' and the info is in sheet1 cell S17, please can you help? I have tried... [CODE]Private Sub TextBox310_Change() Dim WB as...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top