i m a SAP developer and i m developing one interface where data
maintanance of SAP will be done through EXCEL.
I am new in EXcel/VBA. I wanted to create one list box in each data row
of the excel dynamically and also wnated that list box events shd also

I try to set relation between A.Line_id field type = Double vs. B.Reference_3
field type = String, it's not work.
Here the Sample:-
strseparate = Chr(13) & " " & Chr(10)

Hi there. This is my first time posting on this forun, but I have read
through much of the content, and I feel good about the participants. Here is
my problem...
I have written Excel Automation code to create import templates for

i've been looking around why the all paste type does not include column
widths, shouldn't it be "all except for column widths", any good reason
for this? thanks!

Hi, below I have the code I use to make a new sheet using a list for
the names. Is there a way I can integrate code that will change the
color of the sheet tab randomly upon creation of the sheet?
Thanks!

This is on Sheet 6
Option Explicit
Private Sub Worsksheet_Change(ByVal Target As Range)
   Call Missing

I have a field formatted like the following:
2340/LEFT EYE BLINDNESS, 2341/CAP PRES-
2340/LEFT EYE BLINDNESS, 2341/CAP PRES-
2340/LEFT EYE BLINDNESS, 2341/CAP PRES-

I am trying to set up a reminder box to pop-up via excel. This is currently
working using OnTime. However, it only pops-up in Excel. I'd like to make it
appear on top of all my windows so I can see it (otherwise it's not a very
good reminder is it?) Any help on this?

I have a cell with the following data:
144.049S
The S means the number should be subtracted, so I want to turn it into a
negative value. My code is:

Hi, I have a userform with 3 pages using MultiPage control
Each page has several textboxes where the user have to input numbers.
I wanted to make sure the user inputs numbers so I tried two methods.
Basically when the user inputs a non-numeric value, I wanted to set the

I am in a bit of a pickle with a project at work. I am being asked to have a
single cell, which does not reference any other cell, to create an increasing
number each time the formula is ran.
I am stymied with this one; does anyone have any clue on how I can get this

Hi all again,
I was trying to do what the subject said. I used:
Application.Goto Sheets("Requirement").Range(cell_Name)
I found this code in Microsoft MSDN, but... seems it is not working...

I have in Sheet1.
B17 = January 07
B18 = February 07
      ...

If CheckBox1 = False And CheckBox2 = False And CheckBox3 = False And
CheckBox4 = False And CheckBox5 = False Then GoTo Here
Sheet1.Unprotect
Dim rngFound As Range

I am trying to write a UDF that will calculate an employee's estimated
tax (employee paid) by accepting variables such as certain tax rates
and caps as well as a range variable.  The range variable represents
the monthly gross salary from January to December (the range has to be