interface

Have a .txt file that contains specific data that needs to be extracted and placed into corresponding columns in Excel. New to VBA coding so having difficulty in making this work... below shows the code I have thus far but when run, it only extracts the first set of data but does not move onto...

Hi, all - I have an inventory interface we use to track items that have left our store location without payment. We would like to make the interface more detailed, so we have uploaded our Master SKU List into the same Excel workbook (this includes inventory levels, item description, etc.)...

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...