interface

Hi there, I have 5 different combo boxes - each combobox corresponds to a different column. I have labelled the combo box as 'cbo' followed by their column as such: cboDocumentSort = column B cboDocumentRef = column C cboRelatedRef = column D cboEngineType = column K cboUnitType = column L I...

Hi there, I currently have a command button and when pressed a userform interface appears. However if a filter is on in the spreadsheet and I press the command button a message box appears stating that "filters are on. please turn off filters before entering information in the userform" - then...

Hi, First post here, as have hit a real stumbling block that is crucial to an application I am writing. I have an Interface Class - coreIReport - it is instantiated as PublicNotCreatable I have a sheet object in the solution (under Microsoft Excel Objects). It has the code behind with...

I am making an inventory system for a consultant who buys products and sells them at vendor shows. I have a simple table in Access that holds the quantity of each item the consultant has. I would like to be able to use Excel as a front-end interface for manipulating this data (through...

Hey all, first time here. I'm having a little trouble opening a userform in excel. I've never created a userform before. I have some experience in MS Access, but not much in Excel. The userform I've created is an interface to help users easily enter information, which is then transferred to a...

I would like to create a Interface [document] that I can put the button for many userform, which will report to the designated excel wkbks. Can I set up this document so multiple users can open it at the same time? Would all users be able to enter data into the each userform? At no time...

I have a powerpoint presentation where on one slide I can input two values in a table. I want to be able to have those two values automatically link to a spreadsheet stored on a memory card, into cells A122 and A127, and then the spreadsheet (behind the scenes invisibly) calculates via already...

Hi, I'm trying to make a single pivot table available to multiple users for a variety of purposes. I've tried a limited amount of training, but as soon as anyone hears the word 'pivot' they run scared... I'd like to set up a user interface so that the pivot table doesn't look like a pivot...