Posts by turkey

There are 10 textboxes on the userform.

As I enter date into textboxes, I want to add a chechbox right next to it. If such a thing is possible, can you help?

RoyUK master

thank you. So glad that I have you.

Royuk Master

It's perfect, thank you.

But; TextBox (1-9) is not transferred to the page. Can you look if I asked?

Royuk Master

Labells in bulk G6: One time to the AK6 range

TextBox also need the Macro code to save the lower ALTA in each record of the AK7 interval.

I need a code to transfer the data in textboxes between 1-31 on the userform into cell G7: AL7 at once. Can you help?

Let my Master Show the number 25 in cell A1 (10 + 15) when we enter numbers in cell a1 (example number 10), and then enter numbers in cell A1 again (example number 15). I tried to do this, but I couldn't. Therefore, I requested your help.

Sevgili ve saygıdeğer efendim

Aynı hücreye sayı yazarken toplama

My master

When I transfer the digit entered in textbox3 to the cell

I need your help to overlap the numbers in the K3: K range in the transferred cell. Could you help me if I ask?

My master

you are one

My master

Thank you very much for your help. Good thing you are. Health to your hands

My master

Run time error gives error 13.

My master

Starting Date

When we add Days or Months or Years, I need the code for the new date to automatically come to the Due date.

Could you help me if I ask?

.Cells(sonsat, "K") = .Cells(sonsat, "H") + .Cells(sonsat, "I") + .Cells(sonsat, "J")

My master;

I solved the issue

Private Sub CommandButton1_Click()
Dim i      As Long
Dim sonsat As Long
Sayfa3.Range("A2:M65536").ClearContents
For i = 0 To ListBox1.ListCount - 1
sonsat = Sayfa3.[A65536].End(3).Row + 1
If ListBox1.Selected(i) = True Then
With Sheets("BORDRO")
.Cells(sonsat, "A") = sonsat - 1
.Cells(sonsat, "B") = ListBox1.List(i, 1)
.Cells(sonsat, "C") = ListBox1.List(i, 2)
.Cells(sonsat, "D") = ListBox1.List(i, 3)
.Cells(sonsat, "E") = ListBox1.List(i, 4)
.Cells(sonsat, "F") = ListBox1.List(i, 5)
.Cells(sonsat, "G") = Format(Sheets("SGK PRİM ORANLARI").Range("F4").Text, "#,##0.00") * 1
.Cells(sonsat, "H") = Format(Sheets("SGK PRİM ORANLARI").Range("F4").Text, "#,##0.00") * 1 * Format(Sheets("SGK PRİM ORANLARI").Range("C3") / 100, "#,##0.00")
.Cells(sonsat, "I") = Format(Sheets("SGK PRİM ORANLARI").Range("F4").Text, "#,##0.00") * 1 * Format(Sheets("SGK PRİM ORANLARI").Range("C4") / 100, "#,##0.00")
.Cells(sonsat, "J") = Format(Sheets("SGK PRİM ORANLARI").Range("F4").Text, "#,##0.00") * 1 * Format(Sheets("SGK PRİM ORANLARI").Range("C5") / 100, "#,##0.00")

My master;

According to the code system above

Sums.

.Cells (sonat, "K") = How do I get the part?

Can you help me?

royuk ustam

I adjusted the way you say.

I gave you a lot of trouble. Therefore, I apologize.

royuk ustam

UserForm1 "EXIT" then closed with a button I can not log data to any cell in the excel sheet.

Still, your help, thank you for your interest and your relationship. Best regards

Günaydın efendim.

Tehlikede LEAVE düğmesi var.

Kontrol ettikten sonra hücrelere giriş yapamıyorum.

my royUK master

you are my roadmap Thank you for your help.

The file is attached. But novice business please ignore my mistakes.

Ustalarım

Kullanıcı formunu "unload me" ile kapattıktan sonra, excel sayfasında herhangi bir hücre yazamıyorum.

Alt + F11 ile vba bölümüne gidip sıfırladıktan sonra hücrelere yazabiliyorum. Nerede yanlış yaptığımı bilmiyorum ama sorarsam, bu durumdan kurtulmak için bir kod bulmama yardım edebilir misin?

Usta çok teşekkür ederim

Bordro hesaplamak için kullanacağım