new in vba

[dilipgr]

in <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> i'm taking report for performance so i'm creating userform the properties are combobox1, dtpicker1, textbox1 & commandbuttton1.

Station	01/01/2015	02/01/2015	03/01/2015	04/01/2015	05/01/2015	06/01/2015
MON	TUE	WED	THU	FRI	SAT
AKM
APK
ARR
ART
ASD
ATR
BTU
CDM
CGL
CJB
CMM

<tbody>
</tbody>

station in A column is combobox1, dtpicker is date ie, 1/1/15.....5/1/15 if i select combobox1 CJB and dtpicker 3/1/15 then give the value 100 in textbox1 and click commanbutton1 the value of 100 is placed in D13.


regards
Dilipkumar.V
windows7 excel 2007

 

[royUK]

Your dates don't correspond to the days.

I wouldn't use a datePicker because they are not always available. If you use ComboBoxes for both the data and the Station then you can simply use the ListIndex Property to write to the correct column.

See this example

 

[dilipgr]

royuk

thank to so much its cool.........