Excel Simple Program Problem

[nabzy]

---

Good Afternoon guyz... this is my first time posting here in the Software Category.. I want ur help guys... this is how it goes:


Akong gusto sa akong Excel is kada open nko, gusto nko automatic mu-increment na ang ID Number..
Bali number ra jd akong gusto i auto-increment kay kada number lahi2x man ug information gni...
Nangita kos Google pero wla man makahatag gud or naa lng koy wa masabtan tingai...

Any idea guys? help me, this is very important for my Project..

Simple ra jud akong gusto, Kada open sa file, mu-auto increment na ang ID number nya.... ang limit sa id number is Unlimited diay... thank you... i'll be visiting this thread from time to time.. thank you istoryan...

[nabzy]

Wlay mga idea? Asa nmn tong mga Expert dri sa istorya?....

[trojan_vaughn]

Bro, what number are you talking about? Is it a number found in one of the column in your excel sheet? If it is , then you need to add macro objects for incrementation.

Perhaps this link will point you in the direction you want.http://www.excelforum.com/excel-prog...ent-count.html

[darkhero]

i-upload imong excel file bro.. tabangan tka...

[ChaosOrb]

Kindly try this solution:

1. Create a new Excel WorkBook
2. Goto A1, type ID:
3. Save the workbook (any filename you want, make sure the file supports macros, else it won't work)
4. Press Alt+F11
5. When VBA IDE is loaded, double-click "ThisWorkbook"
6. On the (General) drop-down listbox, select Workbook
7. Type the code below:

   Application.Goto ActiveWorkbook.Sheets("Sheet1").Cells(1, 2)
    
    If IsEmpty(ActiveCell.Value) Then
        ActiveCell.Value = 1
    Else
        ActiveCell.Value = ActiveCell.Value + 1
    End If

8. Save the code, close the VBA editor.
9. Save the Excel Workbook again, then close the whole Excel Workbook
10. Open Excel Workbook, enable Macros if you are asked to.

Let me know what you think.

Resources | Reference: http://support.microsoft.com/kb/291308

[nabzy]

Kindly try this solution:

1. Create a new Excel WorkBook
2. Goto A1, type ID:
3. Save the workbook (any filename you want, make sure the file supports macros, else it won't work)
4. Press Alt+F11
5. When VBA IDE is loaded, double-click "ThisWorkbook"
6. On the (General) drop-down listbox, select Workbook
7. Type the code below:

   Application.Goto ActiveWorkbook.Sheets("Sheet1").Cells(1, 2)
    
    If IsEmpty(ActiveCell.Value) Then
        ActiveCell.Value = 1
    Else
        ActiveCell.Value = ActiveCell.Value + 1
    End If

8. Save the code, close the VBA editor.
9. Save the Excel Workbook again, then close the whole Excel Workbook
10. Open Excel Workbook, enable Macros if you are asked to.

Let me know what you think.

Resources | Reference: How to select cells/ranges by using Visual Basic procedures in Excel

It works! thank you kaayo ninyo guys... hehehe... salamat jd kaau... naa pakoy follow-up question sir, unsa-on pag autoenable sa macro? para dli na mu-prompt gni once inig open nko sa file? thank you jd... naa ra jd sa istorya.net tnan...hehe...

[salbahis]

nice.... mingaw nakog VBA.... its been a while since ive seen such code.... ive made a excel sheet before katong naa pako sa innodata... i have to kay maka buang kung mag manual...

[ChaosOrb]

nabzy: If you are using Office 2007, go to Excel Options, then click on Trust Center. After that, click on the Trust Center Settings. Another window will popup, then select Macro Settings, then select the appropriate option to enable macro.

[nabzy]

@ChaosOrb: Thank you so much... hehe... solved na...

naa pakoy umaabot na questions.. mu-posr ra ko dri nga thread ghpon ha..

[ChaosOrb]

@ChaosOrb: Thank you so much... hehe... solved na...

naa pakoy umaabot na questions.. mu-posr ra ko dri nga thread ghpon ha..

No problem and you're welcome, I'm glad to be of helped! Cge mag.paabot ko sa imong next question.