user form

Hi all I was hoping someone could help me. Many years ago i built a userform, through which i can select two sets of numbers and the form will then analyse the numbers for me. It has always worked fine and continues to do so. I want to change it though and add another calc to give me the %...

Hi, Thanks to all the posts on here I have been able to copy, paste, butcher and fudge my way through to almost what I need. I have a sheet with multiple columns with a list of sites which we may visit to carry out a Test, service, Repair or any combination of the three. <tbody> Site A...

Hi, I'm working on a workbook (contains two sheets) that users can log certain data with a user form I created. I'm new to vba but doing pretty well, however one of the areas I'm struggling with is on the form creating a button, and when the user clicks it it saves the active work sheet to a...

Hi I am building a workbook to compile selected months into quarterly and perhaps semi-annual and annual reports. I created a user form so the user can select the "Year", the "FirstMonth" and the "LastMonth". This works perfectly. The full month name is part of each workbook containing...

Dear All, I am using an input box to get the user input. With the user input, I am setting autofilter criteria. Here is the code: Dim SelSeg As String ActiveWorkbook.Sheets("Jan 2015").Activate Range("a1").Select SelSeg = InputBox("Please enter name of segments for which you are...

Hi, I have a user form where I have used the below code to remove the title bar but the problem is the unload me sub doesn't work. Can somebody help with the code for user form load me button. Also if soembody can help me with the code to auto populate some of the text boxes based on the combo...

Hi excel gurus. I've got a user form which collects some metadata. For users convenience this metadata gets sorted in a s/s by two columns J & L with a worksheet calculate event. the problem occurs with data that is beyond sorted column J, so whatever gets written in columns further to it...

Hi All, I had a thread on here a couple of weeks ago which a member was helping me with but he is no longer able to help me due to other commitments. This is the thread was "Search Multiple Worksheets using a User form and display in list box." I have tried myself to complete the code for the...

If anyone can do this lab that is due Wednesday for me I will honestly paypal you $10. I know this is a breeze for most of you and I would typically try and knock it out myself but I have a Prob&Stats exam tomorrow and a Deterministic Exam Wednesday that I really need to focus on and have no...

I have a spreadsheet of data that runs up to column AWI, with just over 2,500 records. I do not have the option of transferring this data to a relational database, which would be my preference. On any given day, team members need to update various subsets of the data. The most common set runs...

I've been handed an Excel spreadsheet with almost 80 unique fields, which filter out into nine separate tabs - with different sets of columns and filtered data. I'm comfortable creating code to filter out the various reports from a central spreadsheet with all the data. Now I've been asked to...

Hi, I have a listbox that contains some files address and I can open that files by dable clicking on listbox items. Now, is there any way to see the files preview in an imagebox, by clicking the list box items? the files can be any thing, maybe word, Excel, PDF, or even Autocad thank you.

Afternoon, I'm currently building a VBA user form that will be used for ticking off friend referrels from current customers. Existing customers can refer up to 5 friends to us - so my userform firstly needs to check the old policy number against the list that has already been compiled and if...

I apologize if this has already been answered or in the wrong section. I have looked for the answer in many places on the internet, including this website, and haven't found my answer. The intent of the macro is to create a form that will enter in Item details and the state it will be shipped...

Hi there, I'm working on a project in which I want a certain sheet to only visible to a certain person with the admin password. Before I used an inputbox as the admin user password form. Worked perfectly. I made a macro as followed: Sub ShowPassForm() ' Show password input box ibo =...

I'm trying to learn some VBA to set up a draft board for fantasy football and was hoping for some help. I currently have a table with the Player Name (column G), as well as two sets of check boxes (columns C & D) indicating whether they've been drafted by an opposing team or myself. The check...

I have userform to enter data and the worksheet. There are 21 textboxes and command buttons which are perfectly fine. The problem im facing is with 2 spinbuttons which scrols through the entered data and also populates the respective textboxes in the userform. Those 2 spinbuttons are with...

Hey guys I'm still very very new to this, I've been working in excel for a month total now, if that. I have a userform that auto pops the date, and user login, has a combobox to pick options from, as well as a notes field. I was able to write/mod/copy enough so when you click on the 'submit'...

Hello. I'm using Excel 2007. I'd like to create a sort-of ever-present, floating note that helps me navigate quickly through my alphabetically organized sheet. The most direct/quickest way I've found to navigate up & down a sheet is via the Name Box. What I'd like to have is a floating note (or...

Hi people, I'm new to VBA. I have created a userform that successfully submits to another sheet in the same workbook. However, I want to replicate the user form so that 15 or so users can submit their end of day KPIs to a worksheet in a separate, shared workbook - if only macro-enabled workbooks...