userform combo box

Hello everyone, I am working on a UserForm where on click on button embedded objects will be open. I am using below codw for this which is working fine. However i want objects (workbook) should open as read only so no one can edit the same. Pls help Private Submit_click () If cmbox.value =...

Ok, I've been slaving over this problem and even after 2 days of trying I only feel close by 20% if that. Goal: Create a dashboard with personnel's training information that they can print or click on hyperlinks (embeded) to specific course sites. This dashboard - snapshot as I am calling it -...

Newbie to VB and I'm struggling to find a code to complete the above. I have a UserForm for with 2 combobox's, the first is for category ("cmbCat") and the second for supplier ("cmbSup"). I would like to be able to upon initializing the form list data from "Table5[Category]" on worksheet...

Hello there, I need multiple users in various Fantasy groups to populate a worksheet for me. I don't want the exercise to be cumbersome, hence a Userform. I need to achieve the following: User Selects their group (sample options below): Fantasy Group 123 Fantasy Group 1234 Fantasy Group 12345...

Hi to all, Complements to this website for giving me the answers I seek consistently. My question is very basic but want to follow accepted procedures and practices. My userform contains name, address, and email. Name is a combobox and contains over 4000 names, other fields are textboxes. I can...

Hey everybody, I've been working on this project for months now and I'm getting towards the end of my timeline. The idea was to have the end user fill out the "Request" form, which is all recorded and stored in the "DataLog" sheet (hidden). Then once the request is satisfied, the end user will...

I cannot thank this board enough! This is my first major post/request. (Many thanks to Rick and AlphaFrog for their contributions to this) So, I have a userform to record very simple payroll data. The user selects a worker (individual), work performed, and then enters a quantity...

Hello! I hope someone can help me. I am desperately trying to accomplish the following; I have an userform(FormEntry) with 6 combo boxes. However, all 6 combo boxes reference the same range(Courses) under column "C" in sheet(Ranges-Lists). What I need is for the boxes to continue referencing...

Hi, i designed a userform for data entry using comboboxes and a textbox (blue in the image), the data selected in the white comboboxes will be multiplied by the number in the yellow comboboxes and the result to be displayed in the blue text box. everything works but the display gets nothing ...

I wanted to make a drop down userform with 3 levels. (Level 1 decides Level 2 decides Level 3). The goal is to have the users of the form be able to select from drop downs to get to level 3 instead of having to look through all the level 3 items. I was able to get 1 and 2 to work however...

Hi Team, What I am trying to achieve: On my user-form, there is a textbox user's can enter a value. Following the textbox is a combo box. I am looking for a way that the combo box can vlookup the value in the textbox to determine it's (the combo box) own value. I can do this by creating...

HI Guys, New to vba, but trying to learn i need a little help with this? I have a combo box which i have made with visual basic in excel 2013. i have a button when it's clicked it brings up the combo list box userform & it has five names in the list. What i would like to do is. When i click...