| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if number already are in the sheet
Hi
Can some one help me I need a code where i can write a number maybe in a inputbox then the code shall see if the number i write already are in the row, if Not write the number in the activecell , and if the are there error by msgbox or something like that Hope some one can help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if number already are in the sheet
You don't need a macro. You can use validation... Try this. Highlite column A
(A1 should be the active cell). Select Data|Format -Custom and add this formula =COUNTIF(A:A, A1) =1 Now try adding values into column A. It should not allow duplicates... -- HTH... Jim Thomlinson "alvin Kuiper" wrote: Hi Can some one help me I need a code where i can write a number maybe in a inputbox then the code shall see if the number i write already are in the row, if Not write the number in the activecell , and if the are there error by msgbox or something like that Hope some one can help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if number already are in the sheet
Thanks
Alvin "Jim Thomlinson" skrev: You don't need a macro. You can use validation... Try this. Highlite column A (A1 should be the active cell). Select Data|Format -Custom and add this formula =COUNTIF(A:A, A1) =1 Now try adding values into column A. It should not allow duplicates... -- HTH... Jim Thomlinson "alvin Kuiper" wrote: Hi Can some one help me I need a code where i can write a number maybe in a inputbox then the code shall see if the number i write already are in the row, if Not write the number in the activecell , and if the are there error by msgbox or something like that Hope some one can help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check Activesheet for chart sheet or work sheet | Charts and Charting in Excel | |||
| Check if the first sheet is the selected sheet | Excel Programming | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| Check if sheet name is a number | Excel Programming | |||
| how to use sumif function to check date in 1 sheet is < 2 sheet | Excel Worksheet Functions | |||
Linear Mode
