PDA

View Full Version : Retrieve formulas and autocomplete



suculeiz1
11-09-2022, 03:31 PM
How to make every time I start excel, the formulas that are entered in column J13:J57 come back?



=SEERRO(I13*$F$13;"-")
=SEERRO(I14*$F$13;"-")
=SEERRO(I15*$F$13;"-")
=SEERRO(I16*$F$13;"-")
=SEERRO(I17*$F$13;"-")
=SEERRO(I18*$F$18;"-")
=SEERRO(I19*$F$18;"-")
=SEERRO(I20*$F$18;"-")
=SEERRO(I21*$F$18;"-")
=SEERRO(I22*$F$18;"-")
=SEERRO(I23*$F$23;"-")
=SEERRO(I24*$F$23;"-")
=SEERRO(I25*$F$23;"-")
=SEERRO(I26*$F$23;"-")
=SEERRO(I27*$F$23;"-")
=SEERRO(I28*$F$28;"-")
=SEERRO(I29*$F$28;"-")
=SEERRO(I30*$F$28;"-")
=SEERRO(I31*$F$28;"-")
=SEERRO(I32*$F$28;"-")
=SEERRO(I33*$F$33;"-")
=SEERRO(I34*$F$33;"-")
=SEERRO(I35*$F$33;"-")
=SEERRO(I36*$F$33;"-")
=SEERRO(I37*$F$33;"-")
=SEERRO(I38*$F$38;"-")
=SEERRO(I39*$F$38;"-")
=SEERRO(I40*$F$38;"-")
=SEERRO(I41*$F$38;"-")
=SEERRO(I42*$F$38;"-")
=SEERRO(I43*$F$43;"-")
=SEERRO(I44*$F$43;"-")
=SEERRO(I45*$F$43;"-")
=SEERRO(I46*$F$43;"-")
=SEERRO(I47*$F$43;"-")
=SEERRO(I48*$F$48;"-")
=SEERRO(I49*$F$48;"-")
=SEERRO(I50*$F$48;"-")
=SEERRO(I51*$F$48;"-")
=SEERRO(I52*$F$48;"-")
=SEERRO(I53*$F$53;"-")
=SEERRO(I54*$F$53;"-")
=SEERRO(I55*$F$53;"-")
=SEERRO(I56*$F$53;"-")
=SEERRO(I57*$F$53;"-")


I managed to make it show some information inserted in my column in a combobox, but as I force it to show, for example, when I select the information from column C1 in ComboBox8, it automatically shows D1 in Combobox9?



Private Sub UserForm_Activate()

'ComboBox8
Dim totLIN2 As Long, LIN2 As Long
totLIN2 = Plan2.Range("C" & Rows.Count).End(xlUp).Row
ComboBox8.Clear
For LIN2 = 1 To totLIN2
ComboBox8.AddItem Plan2.Cells(LIN2, 3)
Next

'ComboBox9
'test

End Sub