1
I have a form where there is a Listview, and textbox for data input and already by login I can filter a column, to appear only the fields I want.
Where is the problem? the intention is, I click on the line of Listview, inputar the values of predicted and realized and this apply, put this value both in Listview (What is working) and Add to filtered line in excel (that’s the problem)
It does not pull the cell I selected, it always plays in the 1 excel cell.. so in this case, I believe I need somehow this button to insert only value into the visible cell that I selected.
Follow the form print and apply button code!
Private Sub CommandButton5_Click()
Sheets("Treinamentos Tableau").Select
Dim PosiçãoAtual As Variant
PosiçãoAtual = Treinamentos.SelectedItem.Index + 1
Cells(PosiçãoAtual, 3).Value = TextBox6.Text
Cells(PosiçãoAtual, 4).Value = TextBox7.Text
With Treinamentos
.SelectedItem.SubItems(2) = TextBox6.Text
.SelectedItem.SubItems(3) = TextBox7.Text
End With
End Sub
---------------- EDIT, EXPLANATION WITH PRINTS ---------------
Explanation 1 : I logged in and password, with a unit and it filtered only that unit, correct? soon I will click on the line I want, put the values of predicted and realized in the textbox and click apply.
Explanation 2 : I clicked to apply, in listview, he was in the right place, show, is in Taquari, December as was the line I selected
Explanation 3 : When I go in the excel spreadsheet, it does not pull the filtered line that I entered the value, it is going to the line that I did not Filtrei, that in case so picking up the invisible lines after I apply the filter
I didn’t understand very well, has a [mcve]?
– danieltakeshi
I put an explanation now, complete and with prints Daniel.
– Gabriel Menegueli