Geeta2014
New Member
- Joined
- Aug 9, 2014
- Messages
- 16
- Office Version
- 2019
- 2016
- 2010
- Platform
- Windows
Hi All,
i can find my way around vba [I am more of an Excel formula user]. Every now and then I need to use one of these. Right now, I am going through the forum and i most likely will find code pieces of what I need, and then i will combine.
However, perhaps one of you good souls already have a vba code that can accomplish what I need. I have laid it out logically as i can below. After the vba runs [whether I add or I delete], I'd like to automatically transfer the updated data to a Word file [tell me if its possible or impossible].
[TABLE="width: 824"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]=(ROW()-1&"=")[/TD]
[TD]Argentina[/TD]
[TD]=(ROW()-1&"=")Argentina[/TD]
[TD] [/TD]
[TD]Need a vba code that will:
1. Search for a specific string (e.g. Barbados) that I type into an input box, Delete the row with Barbados
I also want the code to loop through and make sure the the text in Column B is in alphabetical order. (If there is a way to add numbering plus the equal sign within the code so I no longer need Column A, i am open to that also). [/TD]
[/TR]
[TR]
[TD]2=[/TD]
[TD]Aruba[/TD]
[TD]2=Aruba[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3=[/TD]
[TD]Barbados[/TD]
[TD]3=Barbados[/TD]
[TD] [/TD]
[TD]2. Need code that will loop through Column B, confirm that what I type in an input box is not present in Column B, and once confirmed, code will Add in alphabetical order a new country (e.g. Venezuela). (If there is a way to add numbering plus the equal sign within the code so I no longer need Column A, i am open to that also). [/TD]
[/TR]
[TR]
[TD]4=[/TD]
[TD]Bonaire[/TD]
[TD]4=Bonaire[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5=[/TD]
[TD]Chile[/TD]
[TD]5=Chile[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6=[/TD]
[TD]Curacao[/TD]
[TD]6=Curacao[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7=[/TD]
[TD]St Lucia[/TD]
[TD]7=St Lucia[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8=[/TD]
[TD]Trinidad[/TD]
[TD]8=Trinidad[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
i can find my way around vba [I am more of an Excel formula user]. Every now and then I need to use one of these. Right now, I am going through the forum and i most likely will find code pieces of what I need, and then i will combine.
However, perhaps one of you good souls already have a vba code that can accomplish what I need. I have laid it out logically as i can below. After the vba runs [whether I add or I delete], I'd like to automatically transfer the updated data to a Word file [tell me if its possible or impossible].
[TABLE="width: 824"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]=(ROW()-1&"=")[/TD]
[TD]Argentina[/TD]
[TD]=(ROW()-1&"=")Argentina[/TD]
[TD] [/TD]
[TD]Need a vba code that will:
1. Search for a specific string (e.g. Barbados) that I type into an input box, Delete the row with Barbados
I also want the code to loop through and make sure the the text in Column B is in alphabetical order. (If there is a way to add numbering plus the equal sign within the code so I no longer need Column A, i am open to that also). [/TD]
[/TR]
[TR]
[TD]2=[/TD]
[TD]Aruba[/TD]
[TD]2=Aruba[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3=[/TD]
[TD]Barbados[/TD]
[TD]3=Barbados[/TD]
[TD] [/TD]
[TD]2. Need code that will loop through Column B, confirm that what I type in an input box is not present in Column B, and once confirmed, code will Add in alphabetical order a new country (e.g. Venezuela). (If there is a way to add numbering plus the equal sign within the code so I no longer need Column A, i am open to that also). [/TD]
[/TR]
[TR]
[TD]4=[/TD]
[TD]Bonaire[/TD]
[TD]4=Bonaire[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5=[/TD]
[TD]Chile[/TD]
[TD]5=Chile[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6=[/TD]
[TD]Curacao[/TD]
[TD]6=Curacao[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7=[/TD]
[TD]St Lucia[/TD]
[TD]7=St Lucia[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8=[/TD]
[TD]Trinidad[/TD]
[TD]8=Trinidad[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]