refer

Hi Forum, I've written a piece of code that looks in a column and places all unique values in seperate textboxes in a userform. The next step would be referring to these textboxes in the userform code. Whatever I try however (Userform4.Textbox("box1").Value, or Userform.Textbox1.Value), nothing...

I want to create a single formula in a cell that other cells would have values inputted into them and then reference the one formula cell and then in individual cells display the output. Example: (INPUT CELLS)(I WILL REFER TO THESE CELLS IN THE CALCULATING EQUATION AS "X")...

I'm trying to refer to (a row of) cells in a different tabpage within Excel. The Excel file is connected to an external database and I'm using a parameter to select a specific personcode which then returns a set of data belonging to that specific person. I basicly want one tabpage of raw data...

Hello everyone Is it possible for a function to refer to a result of a nested function within it? Example: =if((FUNCTION)=0;0;RESULT_OF_FUNCTION) whereas FUNCTION would be written out as usual, and RESULT_OF_FUNCTION would be an abbreviation refering to the result of the function, without...

Hi, I have a Main excel file contains data like below - Main File - <TABLE style="WIDTH: 330pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=440 border=0><COLGROUP><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 83pt...

Hi, In VBA, I would like to retrieve the column number of a range and have not been successful after trying several variations. The range is actually a single cell. I think I can get it by selecting the range and using ActiveCell.Column, however I do not wish to select the cell, I just want to...