Programming

Excel VBA Populatig UserFrom Contols as Design Time.
UserFrom1.ComboBox1 = "John Howard" The above code populates the control ComboBox1 with the string John Howard. This is just a Runtime with the ComboBox not retaining the string. What is the syntes for populating the control ComboBox at Design Time so that the string is retained even after closing and reopening... 21 Mar 2010 07:14

Manipulating Table data
Hello, I am hoping to work out a method to transform a data table into a running list. The table has identifiers in column A, and product weights in a dynamic number of columns to the right. i.e. Cols B-M. I would like to manipulate the table into a running list of three columns Col A = Value of ID @ row(... 21 Mar 2010 00:29

How to code it in macro?
Does anyone have any suggestions on how to code it in macro? If cell A1 = B1 under ABC sheet on DEF.xls file, then process following code, then nothing. Does anyone have any suggestions on how to code and retrieve value from this specific cells? Thanks in advance for any suggestions Eric ... 21 Mar 2010 02:45

Sort a Column
Hi, This feels like one of those things that is probably really easy but my VBA obviously isn't up to the job :-( On sheet "A" I have a column containing a list of names. On sheet "B" I have the same list of names (not necessarily in the same order) on a different sheet in the same workbook that has a load o... 21 Mar 2010 00:29

Ribbon Customisation
Hi All, I just wanted to know if its possible to to add custom controls to the ribbon by using VBA alone? And what object reference to I need to add, to to this? Any help will be very much appreciated! ... 22 Mar 2010 08:17

Extract last name from Last, First
I know this has to be a common question, but I can't find the answer... Using VBA, I need to extract the last name from the format: Last, First For example: the cell contents extract to a variable the value of JONES, AMY JONES ADAMS, HARRY ... 20 Mar 2010 21:05

odbc connection lost
while reading excel file I am getting the following error [Microsoft][ODBC Excel Driver] The connection for viewing your linked Microsoft Excel worksheet was lost -- Trioum ... 20 Mar 2010 14:21

Combined Cell Value
Hi All, I have list in following format: A B C D E 0 1 2 3 4 Results wanted: F "0","1","2","3","4" One more question is it possible to merge multiple column values into one column without lost the values? Thanks in advance. ... 20 Mar 2010 14:21

copy a hyperlink to another cell
Hi friends, Now i am tried for long time to copy the hyperlinks from a cells to another cells (column beside column) but without good results :) would you help me please? thank you very much -- aya2002 ------------------------------------------------------------------------ aya2002's Profile: 1625 Vie... 20 Mar 2010 12:06

What is the bar and function name for refresh all?
Does anyone have any suggestions on what the bar and function name is for refresh all from external links? I would like to code macro to refresh all from external links, Does anyone have any suggestions? Thanks in advance for any suggestions Eric ... 20 Mar 2010 07:24