View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default Help Converting Cell Formula To VBA Code

Greetings,

I have a formula that is working well in a cell that I need to convert
to VBA code. Here is the ordinal cell formula broken out logically:

IF(G216="",
E216&IF(C216="",
IF(D216="",
"",
", "&D216),
IF(D216="",
", "&C216,
", "&C216&" & "&D216)),
G216)

Here is the conversion from cells to TextBoxes:

C216 = TextBox2
D216 = TextBox3
E216 = TextBox4
G216 = TextBox6

I need to put the result of this formula into TextBox7

Any help would be most appreciated.

TIA

=Minitman