Saltar al contenido
PROGRAMAR EN VBA MACROS DE EXCEL

Como crear una Macro de Excel

 


(adsbygoogle = window.adsbygoogle || []).push({});

 

Como crear una macro, como crear una macro de Excel, como aprender a crear una macro de Excel con VBA, tutorial gratis sobre como crear una macro, forma de crear una macro de Excel, curso de creación de macros, como crear una macro desde el inicio, Manipular código de VBA, como programar una macro de Excel; como modificar el código de una macroprogramar Excel; todas estas preguntas tienen su respuesta en este post. 

Antes de seguir recomiendo leer un excelente libro sobre Excel que te ayudará operar las planillas u hojas de cálculo, haz click acá, si quieres aprender sobre Excel, en inglés, entonces debes hacer click here. Si lo que necesitas es aprender o profundizar sobre la programación de macros con VBA este es unos de los mejores cursos on line que he visto en internet.

  

No se pretende hacer un curso avanzado ni una gran exposición teórica sobre macros de VBA, sino enseñar a crear una macro de Excel desde cero, pero desde un punto de vista totalmente práctico, es muy claro que es necesario algo teoría, pero básicamente voy a dar un enfoque meramente práctico a lo aquí expuesto.

 

Básicamente existen dos caminos para crear una macro de Excel, el más fácil y por ende más limitado, es utilizar la grabadora de macros que trae incorporada Excel, mediante esta herramienta se está condicionado a los movimiento o acciones que podamos hacer con el mause o teclado; es decir si seleccionamos un rango ese rango se podrá seleccionar nuevamente ya que se grabará un código que así lo determina, pero si quisiéramos hacer algo más complejo con las macros la grabadora de macros queda obsoleta, para ello tenemos que recurrir a la programación en VBA, lo cual es más difícil, ya que requiere un cierto conocimiento sobre macros o programación en VBA para poder realizar o modificar alguna macro ya hecha como por ejemplo las macros de este listado.

Comencemos con la grabadora de macro, para poder grabar una macro con esta herramienta provista por Excel se necesita tener habilitado el menu programador, en caso que no este habilitado se debe ir a la pestaña archivos, luego a opciones y por último personalizar cinta de opciones, ahí se debe tildar donde dice programador en las opciones de la derecha, en la figura siguiente se muestra en forma gráfica los pasos expuestos para que aparezca el menu programador.

 

Una vez habilitado el menu programandor, al presionarlo aparece en la cinta de opciones un pequeño ícono que dice «grabar macro» (ver la imagen de abajo), si hacemos click en dicho ícono se abre un cuadro de diálogo para que asignemos nombre a la macro, por defecto siempre sale escrito «macro1» si ya grabamos una macro sale «macro2» y así sucesivamente; una vez hecho esto la grabadora queda en funcionamiento y se graban o mejor dicho se codifica todo lo que seleccionemos, escribamos y demás comandos que ejecutemos con el mause y teclado; para detener la grabación se debe presionar el mismo botón que ahora dice «Detener Grabación».

Antes de continuar, recomiendo que leas un excelente libro sobre Excel el que te ayudará operar las planillas de cálculo, haz click acá, si quieres aprender sobre Excel, en inglés, entonces debes hacer click here. Si lo que necesitas es aprender o profundizar sobre la programación de macros con VBA este es unos de los mejores cursos on line que he visto en internet.

Bien ahora te voy a mostrar el código que genera la grabadora de macros, vamos a realizar algo sencillo como es escribir un nombre, cambiar la fuente y su tamaño, poner negrita seleccionar la celda H100, hacer scroll con el mause para ver dicha celda y seleccionar la celda A1, el código de VBA que genera la grabadora de macros es el siguiente:

Sub Macro1()
‘ Macro1 Macro

    Range(«A2»).Select
    ActiveCell.FormulaR1C1 = «Dayra Col»
    Range(«A3»).Select
    ActiveCell.FormulaR1C1 = «Tomy Lee»
    Range(«A2:A3»).Select
    With Selection.Font
        .Name = «Calibri»
        .Size = 20
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ThemeColor = xlThemeColorLight1
        .TintAndShade = 0
        .ThemeFont = xlThemeFontMinor
    End With
    Selection.Font.Bold = True
    ActiveWindow.SmallScroll Down:=78
    Range(«H100»).Select
    ActiveWindow.SmallScroll Down:=-111
    Range(«A1»).Select
End Sub

 

Ahora explico paso por paso que hace cada parte del código, debes tener en cuenta lo que se expuso más arriba de lo que se iba a realizar para que la grabadora genere el código.

Toda macro empieza con «Sub nombremacro()» y termina con «End Sub», en el código anterior todo texto que tenga apostrofe ( ‘ ) es un comentario solamente y no incide en el código; nuestra macro empieza con

Sub Macro1()

Debes notar que en el nombre de la macro está escrito el nombre que le dimos en el cuadro de diálogo que salió al presionar grabar macro; la macro  termina con

End Sub

Esta parte del código  nos dice que seleccionemos la celda A2 luego escribamos en ella «Dayra Col»; luego seleccionemos la celda A3 y escribamos «Tomy Lee»; posteriormente seleccionamos el rango A2:A3.

    Range(«A2»).Select
    ActiveCell.FormulaR1C1 = «Dayra Col»
    Range(«A3»).Select
    ActiveCell.FormulaR1C1 = «Tomy Lee»
    Range(«A2:A3»).Select

Si se quisiera cambiar el rango seleccionado, se podría manipular el código y cambiar el rango donde se escribe por ejemplo el código establece que se debe seleccionar el rango A2, pero si quisiéramos que «Dayra Col» se escriba en el rango E15, deberíamos usar cambiar el siguiente código:

 Range(«A2»).Select
 ActiveCell.FormulaR1C1 = «Dayra Col»

Por este otro código:

 Range(«E15»)= «Dayra Col»

Luego de la selección se elige la fuente denominada»Calibri» y le da un tamaño 20, posteriormente pone en negrita el texto del rango seleccionado, esto es lo que está ordenando entre otras cosas hacer en el siguiente código.

With Selection.Font
        .Name = «Calibri»
        .Size = 20
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ThemeColor = xlThemeColorLight1
        .TintAndShade = 0
        .ThemeFont = xlThemeFontMinor
    End With
Selection.Font.Bold = True

Para finalizar se da un scroll de 78 y seleccionamos la celda H100, el scroll se hace con la rueda del mause, permite para bajar las celdas y poder visualizar donde esta la celda H100, por último se selecciona la celda A1, dando un scroll de -111 es decir llevamos la página hacia arriba para poder ver la celda A1; esto es lo que ordena hacer el código que está más abajo.

    ActiveWindow.SmallScroll Down:=78
    Range(«H100»).Select
    ActiveWindow.SmallScroll Down:=-111
    Range(«A1»).Select

Para terminar con el tema de la grabadora de macros y pasar a ver como se puede escribir o manipular el código de una macro, cabe aclarar que la grabadora genera aveces un código demasiado largo que puede ser simplificado si es escrito en vez de usar el código que genera la grabadora.

Seguidamente vamos a realizar lo mismo que se hizo con la grabadora es decir escribir en la celda A2 «Dayra Col» en la celda A3 «Tomy Lee», darle un tamaño de 20 y fuente «Calibri», poner el texto en negrita; posteriormente seleccionar la celda H100 y luego A1.

Para escribir el código debemos presionar Alt+F11 con ello se muestra el editor de VBA, tal cual se muestra en la imagen de abajo; una vez cargado el editor de VBA debemos insertar un módulo, para ello vamos al menu insertar, se despliega un submenu, desde ahí debemos insertar módulo, luego en la parte derecha comenzamos a escribir el código que sigue:

Sub Macro2()
Range(«A2») = «Dayra Col»
Range(«A3») = «Tomy Lee»
Range(«A2:A3»).Font.Size = 20
Range(«A2:A3»).Font.Name = «Calibri»
Range(«A2:A3»).Font.Bold = True
Range(«H100»).Select
Range(«A1»).Select
End Sub

Como podemos observar el código escrito directamente en el editor de VBA hace lo mismo que el realizado con la grabadora de macros, sin embargo la codificación de la macro es mucho más simple, desde aquí puedes descargar el ejemplo y ver como funciona.

Para terminar vamos a mostrar un código un poquito más complejo, es bastante útil ya que se presenta un formulario para introducir datos en la celda, primero se va a mostrar el código completo y luego se va a desglosar para explicar paso a paso que realiza cada parte del código o macro.

El vídeo que sigue muestra una explicación más detallada y gráfica de la macro presentada, recomiendo observar para una más fácil comprensión de la macro; suscribe a nuestra web desde la parte superior derecha de la página ingresando tu mail y a nuestro canal de You Tube para recibir en tu correo vídeos explicativos sobre macros interesantes, como  por ejemplo formulario que crea un listado de todas las hojas para poder luego seleccionarlasbuscar en listbox mientras escribes en textboxordenar hojas libro excel por su nombreconectar Excel con Access y muchos ejemplos más.

 

function onYtEvent(payload) {
if (payload.eventType == ‘subscribe’) {
// Add code to handle subscribe event.
} else if (payload.eventType == ‘unsubscribe’) {
// Add code to handle unsubscribe event.
}
if (window.console) { // for debugging only
window.console.log(‘YT event: ‘, payload);
}
}

 

 



Código que se inserta en un módulo


Sub CargaFormulario()
    Load UserForm1
    UserForm1.Show
End Sub

 

Código que se inserta en un formulario

Private Sub CommandButton1_Click()
‘Inserta fila
Selection.EntireRow.Insert
‘LimpiaLimpia Los Textbox
TextBox1 = Empty
TextBox2 = Empty
TextBox3 = Empty
TextBox4 = Empty
TextBox5 = Empty
‘Envia el cursor al Textbox1 para volver a capturar los datos
TextBox1.SetFocus
End Sub

Private Sub CommandButton2_Click()
Unload Me
End Sub

Private Sub TextBox1_Change()
Range(«a2»).Select
ActiveCell.FormulaR1C1 = TextBox1
End Sub

Private Sub TextBox2_Change()
Range(«b2»).Select
ActiveCell.FormulaR1C1 = TextBox2
End Sub

Private Sub TextBox3_Change()
Range(«c2»).Select
ActiveCell.FormulaR1C1 = TextBox3
End Sub
Private Sub TextBox4_Change()
Range(«d2»).Select
ActiveCell.FormulaR1C1 = TextBox4
End Sub
Private Sub TextBox5_Change()
Range(«e2»).Select
ActiveCell.FormulaR1C1 = TextBox5
End Sub

 

Bien ahora explicaré que realiza cada parte del código presentado, este código se debe insertar en un módulo, lo que hace es cargar el formulario1 o Userform1 y mostrarlo, para ello en el ejemplo encontrarás un botón que tiene asignada esta macro y que permite mostrar el formulario al presionar el mismo.

Sub CargaFormulario()
    Load UserForm1
    UserForm1.Show
End Sub

La siguiente codificación va en un formulario, para insertar un formulario se debe seguir los mismos pasos para insertar un módulo, pero en vez de módulo elegir userform.

El código que se muestra a continuación pertenece al botón insertar del formulario, lo que hace es insertar una fila entera en el rango seleccionado actualmente; luego limpia los textbox del 1 al 5 y deja listo para ingresar el nuevo registro, por último hace que el cursor se posicione en el textbox1.

Private Sub CommandButton1_Click()
‘Inserta fila
Selection.EntireRow.Insert
‘LimpiaLimpia Los Textbox
TextBox1 = Empty
TextBox2 = Empty
TextBox3 = Empty
TextBox4 = Empty
TextBox5 = Empty
‘Envia el cursor al Textbox1 para volver a capturar los datos
TextBox1.SetFocus
End Sub

 

Código que se asigna al botón cancelar, al presionarlo hace que se oculte o cierre el formulario.

Private Sub CommandButton2_Click()
Unload Me
End Sub

Código que maneja el textbox1, lo que realiza lo hace justo en el evento change o cuando cambia se modifica el textbox1, en este caso selecciona la celda A2 y luego hace que el valor del textbox1 se copie en la celda A2.

Private Sub TextBox1_Change()
Range(«a2»).Select
ActiveCell.FormulaR1C1 = TextBox1
End Sub

Esta codificación se inserta en el textbox2, selecciona la celda B2 y luego hace que el valor del textbox2 se copie en la celda B2.

Private Sub TextBox2_Change()
Range(«b2»).Select
ActiveCell.FormulaR1C1 = TextBox2
End Sub

Esta código se inserta en el textbox3, selecciona la celda C2 y luego hace que el valor del textbox3 se copie en la celda C2.

 

Private Sub TextBox3_Change()
Range(«c2»).Select
ActiveCell.FormulaR1C1 = TextBox3
End Sub

Esta código se inserta en el textbox4, selecciona la celda D2 y luego hace que el valor del textbox4 se copie en la celda D2.

Private Sub TextBox4_Change()
Range(«d2»).Select
ActiveCell.FormulaR1C1 = TextBox4
End Sub

Esta código se inserta en el textbox5, selecciona la celda E2 y luego hace que el valor del textbox5 se copie en la celda E2.

Private Sub TextBox5_Change()
Range(«e2»).Select
ActiveCell.FormulaR1C1 = TextBox5
End Sub

 

Te invito, desde el link del final, a descargar el archivo de ejemplo de esta manera podrás ver su funcionamiento en forma más detallada. Resumiendo, el código de VBA o Macro de Excel presentado al último muestra un formulario desde el cual se pueden ingresar datos a una base de datos de Excel, desde ya que está a modo de ejemplo y admite muchas mejoras, pero es un buen punto de partida si estás por programar algún formulario que permita manipular e ingresar datos, en el sitio encontrarás muchos ejemplos que te ayudarán a programar tu macro, en los links siguientes hay otros post de utilidad y ejemplos que te servirán mucho.

Seleccionar o referenciar celdas mediante código VBA
Busca un dato en todas las hojas de excel
Combobox incrustado en Excel
Formulario para insertar datos en hoja de excel
Tutoriales sobre VBA
Llenar combobox y buscar datos
Mensaje de Alerta y envío de mail con Excel
Combobox que lista hojas de excel y las selecciona 

 
 
Si te fue de utilidad puedes INVITARME UN CAFÉ y de esta manera ayudar a seguir manteniendo la página, CLICK para descargar en ejemplo en forma gratuita. 


(adsbygoogle = window.adsbygoogle || []).push({});

If this post was helpful INVITE ME A COFFEE and so help keep up the page, CLICK to download free example.

 

Si te gustó por favor compártelo con tus amigos
If you liked please share it with your friends      

Entradas relacionadas

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Comentarios (187)

I am the manager of JustCBD Store company (justcbdstore.com) and am trying to broaden my wholesale side of business. I am hoping anybody at targetdomain give me some advice ! I thought that the most ideal way to do this would be to reach out to vape stores and cbd retailers. I was hoping if anybody at all could recommend a dependable web site where I can get Vape Shop B2B Data List I am currently taking a look at creativebeartech.com, theeliquidboutique.co.uk and wowitloveithaveit.com. Not sure which one would be the most ideal option and would appreciate any guidance on this. Or would it be simpler for me to scrape my own leads? Suggestions?

Responder

Great article! We are linking to this great post on our site. Keep up the great writing.

Responder

Very good info. Lucky me I found your site by accident (stumbleupon). I’ve book marked it for later!

Responder

Hi, I do think this is an excellent website. I stumbledupon it 😉 I will revisit once again since i have bookmarked it. Money and freedom is the best way to change, may you be rich and continue to help others.

Responder

There’s certainly a lot to know about this topic. I really like all of the points you’ve made.

Responder

You need to be a part of a contest for one of the highest quality websites online. I most certainly will highly recommend this site!

Responder

Fascinating blog! Is your theme custom made or did you download it from somewhere?
A design like yours with a few simple adjustements would really make my blog stand out.
Please let me know where you got your theme. Bless you adreamoftrains website hosting
companies

Responder

This is very fascinating, You are a very professional blogger.
I have joined your feed and sit up for looking for
extra of your wonderful post. Also, I’ve shared your site
in my social networks

Responder

I simply want to tell you that I’m very new to blogs and actually savored you’re web blog. Almost certainly I’m planning to bookmark your blog . You really come with very good articles and reviews. Bless you for revealing your blog.

Responder

I just want to mention I am very new to blogging and site-building and honestly savored you’re web-site. Most likely I’m planning to bookmark your website . You amazingly come with awesome well written articles. Thank you for revealing your blog site.

Responder

bookmarked!!, I love your website!

Responder

Pretty! This has been an incredibly wonderful article. Thank you for supplying this info.

Responder

There are some fascinating points in time in this article however I don?t know if I see every one of them facility to heart. There is some legitimacy but I will certainly take hold opinion until I look into it additionally. Excellent article, many thanks and also we want extra! Added to FeedBurner too

Responder

Good post. I learn something new and challenging on websites I stumbleupon on a daily basis. It will always be exciting to read through content from other authors and practice a little something from other sites.

Responder

An outstanding share! I’ve just forwarded this onto a friend who was doing a little research on this. And he actually bought me breakfast simply because I stumbled upon it for him… lol. So allow me to reword this…. Thanks for the meal!! But yeah, thanx for spending some time to discuss this subject here on your website.

Responder

This is a topic which is close to my heart… Thank you! Exactly where are your contact details though?

Responder

Spot on with this write-up, I actually believe that this amazing site needs a great deal more attention. I’ll probably be back again to read more, thanks for the info!

Responder

Great article! We will be linking to this great content on our site. Keep up the good writing.

Responder

There is certainly a great deal to know about this subject. I like all of the points you have made.

Responder

pitkävetovihjeet

Responder

Achieving your fitness goals doesn’t need a certified personal trainer or an expensive gym memberships, it’s not hard to exercise at home. It’s easy to go down a training and fitness rabbit hole, however, when you are looking for the best home exercise equipment to outfit your personal home gym.

Responder

KAISERSLUST Plattform der Wiener Sex Scene Sex in Wien – Girls in Wien – Escorte Wien – Transen Wien – Hostessen Wien Escort Wien – Massagen Wien – Studios Wien – Laufhaus und Bordelle Wien Asiatinnen Wien – Sex in Wien – Kaiserslust – Der Kaiser hat Lust – Sex

Responder

Do you mind if I quote a couple of your articles as long as I provide credit and sources back to
your website? My blog site is in the exact same niche as yours and my
visitors would truly benefit from some of the information you provide
here. Please let me know if this alright with you.
Cheers! 3aN8IMa cheap flights

Responder

“Parrilli is outrageously gifted with unstoppable creativity”

Responder

This is a topic which is close to my heart… Many thanks!
Where are your contact details though? 2CSYEon cheap flights

Responder

Pretty! This was a really wonderful article. Thank you for supplying these details.

Responder

The very next time I read a blog, I hope that it doesn’t fail me as much as this one. After all, Yes, it was my choice to read, nonetheless I really thought you’d have something helpful to talk about. All I hear is a bunch of complaining about something that you could fix if you were not too busy looking for attention.

Responder

Hey there! I just wish to offer you a huge thumbs up for your great information you have got here on this post. I am coming back to your site for more soon.

Responder

Shop; Unique Functions. Simple Product Layouts. Post with review. Advanced Product Layout. Best conversion pages. Frontend Search · Listing example …

Responder

Right now it looks like WordPress is the best blogging platform out there right now.
(from what I’ve read) Is that what you’re using on your blog?

Responder

I would like to thank you for the efforts you’ve put in penning this website. I really hope to view the same high-grade content from you later on as well. In fact, your creative writing abilities has motivated me to get my very own site now 😉

Responder

netticasinot pikakasinot parhaat netticasinot

Responder

My relatives always say that I am wasting my time here
at net, but I know I am getting know-how daily by reading thes nice posts.

Responder

Spot on with this write-up, I truly feel this amazing site needs a lot more attention. I’ll probably be back again to read through more, thanks for the information!

Responder

This is the ideal blog site for anybody that wishes to learn about this subject. You realize a lot its virtually hard to say with you (not that I in fact would want?HaHa). You absolutely put a new spin on a subject thats been covered for years. Great things, simply wonderful!

Responder

Saved as a favorite, I really like your website!

Responder

Welcome to iBeautys Best, iBeautys Best is the number one destination for Latest Beauty Products. Here you can easily buy your desired product from all over the world with very reasonable price.

Responder

This is a topic that is close to my heart… Thank you! Exactly where are your contact details though?

Responder

You need to take part in a competition for among the most effective blog sites online. I will certainly advise this website!

Responder

This is a topic that’s close to my heart… Thank you! Exactly where are your contact details though?

Responder

David-Home Northeast is your premier source for all of your Real Estate investing needs. We provide a variety of solutions for sellers looking to sell fast and investors looking to grow their real estate investment portfolios for better returns. At David-Home Northeast, we are dedicated to improving and redeveloping the areas that we operate in. We specialize in helping sellers of distressed properties (single and multi-family homes, commercial, retail, bank REOs, etc.) find buyers looking to invest. Let us put our network of cash home buyers and private money lenders to work for you so you can say “David” to that old unwanted property.

Responder

Aw, this was an extremely nice post. Finding the time and actual effort to create a top notch article… but what can I say… I procrastinate a whole lot and don’t manage to get nearly anything done.

Responder

Aw, this was a very good post. Finding the time and actual effort to create a top notch
article… but what can I say… I put things off a whole lot and don’t manage to get
nearly anything done.

Responder

We tested coffee makers for the water temperature during the brew cycle and the brewing time as well as the temperature of the coffee at the end of brewing and during the keep warm cycle. In addition, we evaluated each brewer’s ease of use, including how easy it was to read and use the controls, access the water tank and brew basket, read the markings on the tank and carafe, whether or not it had automatic keep warm and shut off cycles, and the ease of cleaning the carafe.

Responder

Oh my benefits! a remarkable post guy. Thank you Nevertheless I am experiencing problem with ur rss. Don?t recognize why Incapable to register for it. Exists any person getting similar rss problem? Anyone who recognizes kindly respond. Thnkx

Responder

How does Ibogaine cure addiction

Responder

Hello there! This article couldn’t be written any better! Looking through this post reminds me of my previous roommate! He always kept talking about this. I’ll send this post to him. Fairly certain he’ll have a good read. Many thanks for sharing!

Responder

Spot on with this write-up, I honestly believe this site needs a lot more attention. I’ll probably be back again to read more, thanks for the info!

Responder

I’m more than happy to discover this web site. I wanted to thank you for your time for this fantastic read!! I definitely loved every bit of it and i also have you book marked to see new things in your web site.

Responder

Natural Releaf CBD | New York CBD Store with locations in Murray Hill, NY | Upper East Side, NY | White Plains, NY Serving New York City, NY and Westchester, NY High Quality CBD Products With Lab Test

Responder

Hey! I know this is kind of off topic but I was wondering which blog platform are you using for this website? I’m getting tired of WordPress because I’ve had problems with hackers and I’m looking at options for another platform. I would be awesome if you could point me in the direction of a good platform.

Responder

Way cool! Some extremely valid points! I appreciate you penning this post and the rest of the website is also really good.

Responder

bookmarked!!, I love your blog!

Responder

Is Ibogaine effective in treating opiate withdrawal

Responder

After research study a few of the post on your internet site now, and I really like your way of blog writing. I bookmarked it to my book mark website list as well as will be checking back quickly. Pls take a look at my web site as well and also let me know what you believe.

Responder

After I initially commented I appear to have clicked the -Notify me when new comments are added- checkbox and now every time a comment is added I get 4 emails with the exact same comment. There has to be a means you are able to remove me from that service? Many thanks!

Responder

You could certainly see your enthusiasm in the work you write. The arena hopes for more passionate writers such as you who aren’t afraid to mention how they believe. All the time follow your heart.

Responder

I couldn’t resist commenting. Well written!

Responder

Love watching sunset !

Responder

Love watching sunset !

Responder

Best view i have ever seen !

Responder

Great post. I was checking continuously this blog and
I am impressed! Very helpful information specifically the last part :
) I care for such info much. I was seeking this
particular information for a very long time. Thank you and best of luck.

Responder

Everything is very open with a very clear description of the challenges. It was truly informative. Your site is very helpful. Thanks for sharing!

Responder

ilmaiset pornovideot, pornovideot, porno videot, pornovideoita, porn videos, free pornvideos, porno video

Responder

Thank you for the good writeup. It in reality was once a entertainment account it. Glance complex to more added agreeable from you! By the way, how can we be in contact?

Responder

for You, Lord, have not forsaken those who seek You. Psalm 9: 9-10 NKJV

Responder

Oh my goodness! a tremendous article dude. Thank you Nevertheless I’m experiencing difficulty with ur rss . Don’t know why Unable to subscribe to it. Is there anybody getting identical rss problem? Anyone who is aware of kindly respond. Thnkx

Responder

investors

Responder

Pretty! This was an extremely wonderful article. Thanks for providing this info.

Responder

Hi there! I know this is kinda off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having problems finding one? Thanks a lot!

Responder

Greetings! Very useful advice within this post! It is the little changes that produce the biggest changes. Thanks a lot for sharing!

Responder

Hey there would you mind stating which blog platform you’re using? I’m planning to start my own blog soon but I’m having a difficult time making a decision between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something completely unique. P.S My apologies for being off-topic but I had to ask!

Responder

Love watching sunset !

Responder

I couldn’t resist commenting. Well written!

Responder

Best view i have ever seen !

Responder

This is a topic which is near to my heart… Many thanks! Exactly where are your contact details though?

Responder

Spot on with this write-up, I seriously believe that this site needs much more attention. I’ll probably be back again to read through more, thanks for the advice!

Responder

After looking into a number of the articles on your site, I honestly appreciate your way of writing a blog. I saved it to my bookmark website list and will be checking back in the near future. Please visit my web site as well and tell me your opinion.

Responder

I amazed with the analysis you made to create this actual publish amazing.

Responder

You actually make it seem so easy with your presentation but I find this topic to be actually something that I think I would never understand. It seems too complicated and very broad for me. I am looking forward for your next post, Iíll try to get the hang of it!

Responder

ilmaiset videot, ilmaiset pornovideot, ilmaiset porno videot, porno video, porno videot

Responder

After looking at a few of the blog articles on your site, I really like your technique of writing a blog. I bookmarked it to my bookmark website list and will be checking back soon. Please visit my web site too and tell me what you think.

Responder

PUMPKIN SPICE

Responder

Hi, Neat post. There’s a problem along with your web site in web explorer, may test this IE still is the marketplace chief and a large component of other people will miss your wonderful writing because of this problem.

Responder

Temperature Screening

Responder

I used to be able to find good information from your blog articles.

Responder

Wonderful post! We are linking to this great post on our site. Keep up the great writing.

Responder

My partner and I absolutely love your blog and find most
of your post’s to be exactly what I’m looking for.

Do you offer guest writers to write content
in your case? I wouldn’t mind creating a post or elaborating on a lot of the subjects you write in relation to
here. Again, awesome blog!

Responder

Great article, just what I was looking for.

Responder

Thanks , I have just been searching for info about this topic for ages and yours is the greatest I’ve came upon so far. But, what about the conclusion? Are you sure in regards to the supply?

Responder

cbd oil

Responder

A deaf husband and a blind wife are always a happy couple.

Responder

I’m impressed, I have to admit. Rarely do I come across a blog that’s both equally educative and interesting, and let me tell you, you have hit the nail on the head. The issue is something that too few men and women are speaking intelligently about. Now i’m very happy I stumbled across this during my hunt for something relating to this.

Responder

We are building consultants. We perform roof assessments, window testing, and wall testing for quality assurance on new and existing buildings.

Responder

A proverb is one mans wit and all mens wisdom.

Responder

Oh my goodness! Amazing article dude! Thank you so much, However I am having troubles with your RSS. I don’t understand why I cannot subscribe to it. Is there anybody getting identical RSS issues? Anyone who knows the solution will you kindly respond? Thanks!!

Responder

Can I simply say what a comfort to find someone who really knows what they are discussing on the net. You actually know how to bring an issue to light and make it important. More people really need to look at this and understand this side of your story. I can’t believe you are not more popular because you surely have the gift.

Responder

Online jewelry boutique specializing in custom gold and silver pieces. For the hippy hearted fashion lover. Known for its custom lotus flower hoop earrings and large collection of hoop earrings. Customers enjoy the classic and unique versatile everyday jewelry designs. Glamour hippy began is also known for its dainty gold jewelry pieces. Bohemian chic styles with modern fashion flare. Great prices and affordable. Everyday pieces to statement piece designs for special occasions. Glamour hippy is inspired by diverse world culture and it reflects into the ever changing designs. Its customer enjoys unique pieces and comfort in style. Glamour hippy wants to be a part of its customers wardrobe for many years and part of great memories where ever the customer takes their jewelry pieces. Glamour hippy is glamour and hippy all in one. Shiny pretty pieces, Unique, Glamorous, boho chic, one of a kind, dainty, but statement worthy.

Responder

An intriguing conversation deserves comment. I believe that you need to compose extra on this topic, it may not be a taboo subject however generally individuals are insufficient to talk on such subjects. To the next. Thanks

Responder

Woah! I’m really enjoying the template/theme of this blog. It’s simple, yet effective. A lot of times it’s hard to get that «perfect balance» between user friendliness and appearance. I must say you have done a great job with this. Also, the blog loads very fast for me on Safari. Outstanding Blog!

Responder

netticasinot, netticasino, casino, kasinot, nettkasinot

Responder

I would like to thank you for the efforts you’ve put in penning this blog. I’m hoping to see the same high-grade content from you in the future as well. In truth, your creative writing abilities has motivated me to get my own, personal blog now 😉

Responder

excellent points altogether, you just gained a new reader. What would you recommend in regards to your post that you made a few days ago? Any positive?

Responder

Hi, I do think this is a great site. I stumbledupon it 😉 I will come back once again since i have book marked it. Money and freedom is the best way to change, may you be rich and continue to help others.

Responder

Aw, this was a really nice post. In thought I want to put in writing like this moreover – taking time and actual effort to make a very good article… but what can I say… I procrastinate alot and certainly not appear to get something done.

Responder

This is a topic which is near to my heart… Thank you! Exactly where are your contact details though?

Responder

Place on with this write-up, I really believe this web site needs far more consideration. I?ll possibly be again to check out far more, many thanks for that info.

Responder

This is the perfect blog for anyone who would like to understand this topic. You know a whole lot its almost tough to argue with you (not that I personally would want to…HaHa). You definitely put a fresh spin on a topic that has been discussed for ages. Great stuff, just excellent!

Responder

I’m excited to discover this page. I want to to thank you for ones time for this particularly wonderful read!! I definitely really liked every bit of it and i also have you saved as a favorite to see new stuff on your blog.

Responder

I really like your writing style, wonderful info, thank you for putting up :D. «If a cluttered desk is the sign of a cluttered mind, what is the significance of a clean desk» by Laurence J. Peter.

Responder

GEM-CAR auto repair shop management software is arguably the most comprehensive software of its kind currently available. Lauded for its easy to use modules including CRM, digital inspection and electronic punch clock: it provides the repair shop operator with a complete system to run the business. GEM-CAR puts the shop operator firmly in the driver’s seat. And if you are a fleet operator look for GEM-FLEET our fleet management software.

Responder

casino en ligne…[…]the time to read or visit the content or sites we have linked to below the[…] w?casino en ligne france…

Responder

Its fantastic as your other blog posts : D, thankyou for posting . «Music is the soul of language.» by Max Heindel.

Responder

Hello there! I could have sworn I’ve been to this site before but after looking at many of the posts I realized it’s new to me. Nonetheless, I’m definitely delighted I came across it and I’ll be book-marking it and checking back often!

Responder

I love it when people get together and share thoughts. Great website, continue the good work!

Responder

i always like Superman and of course the TV Series Smallville, Lana Lang is very pretty too”

Responder

I needed to thank you for this great read!! I definitely enjoyed every bit of it. I have you book marked to look at new stuff you post…

Responder

There is noticeably a bundle to know about this. I think you ensured good points in attributes also.

Responder

Hello! Do you use Twitter? I’d like to follow you if that would be ok. I’m undoubtedly enjoying your blog and look forward to new updates.

Responder

Hey there! I just would like to offer you a big thumbs up for the great info you have got here on this post. I’ll be returning to your website for more soon.

Responder

I could not resist commenting. Well written!

Responder

Good post. I’m dealing with some of these issues as well..

Responder

you’re really a good webmaster. The website loading speed is incredible. It seems that you’re doing any unique trick. Also, The contents are masterpiece. you have done a wonderful job on this topic!

Responder

pikakasinot, kasinot ilman rekisteröitymistä

Responder

It?s tough to find knowledgeable people on this topic, however you sound like you recognize what you?re talking about! Thanks

Responder

Is this 2 player? So would your friend have to hide his eyes while you look at your cards?

Responder

I loved as much as you will receive carried out right here. The sketch is attractive, your authored material stylish. nonetheless, you command get bought an nervousness over that you wish be delivering the following. unwell unquestionably come more formerly again since exactly the same nearly very often inside case you shield this increase.

Responder

I would like to show my affection for your generosity giving support to men who actually need help on the question. Your very own commitment to getting the message all around appears to be remarkably advantageous and has specifically allowed folks just like me to get to their pursuits. Your entire invaluable key points denotes so much a person like me and still more to my office colleagues. Thanks a ton; from all of us.

Responder

Hi there! This blog post couldn’t be written any better! Looking through this article reminds me of my previous roommate! He always kept preaching about this. I will forward this article to him. Pretty sure he’s going to have a good read. Many thanks for sharing!

Responder

pitkävetovihjeet

Responder

wonderful points altogether, you simply won a new reader. What would you recommend in regards to your post that you just made a few days in the past? Any certain?

Responder

Hi, I do believe this is a great site. I stumbledupon it 😉 I’m going to return once again since i have book marked it. Money and freedom is the greatest way to change, may you be rich and continue to guide other people.

Responder

It’s wonderful that you are getting thoughts from this post as well as from our argument made at this time.

Responder

italian foods are very tasty and most of their recipes are heart friendly too`

Responder

You’ve made some really good points there. I looked on the web for more info about the issue and found most people will go along with your views on this site.

Responder

The other day, while I was at work, my cousin stole my iPad and tested to see if it can survive a twenty five foot drop, just so she can be a youtube sensation. My apple ipad is now destroyed and she has 83 views. I know this is entirely off topic but I had to share it with someone!

Responder

The very next time I read a blog, I hope that it won’t fail me as much as this particular one. I mean, Yes, it was my choice to read through, but I genuinely believed you’d have something helpful to talk about. All I hear is a bunch of moaning about something that you can fix if you weren’t too busy searching for attention.

Responder

Find The Top Rated Web Hosting

Responder

My partner as well as I love your blog site and also locate almost all of your article’s to be simply what I’m trying to find. Do you use visitor authors to compose content for you? I would not mind creating a message or clarifying on some the subjects you write over here. Once more, awesome weblog!

Responder

I think other website proprietors should take this web site as an model, very clean and great user friendly style and design, as well as the content. You’re an expert in this topic!

Responder

Lovely blog! I am loving it!! Will be back later to read some more. I am taking your feeds also.

Responder

I do accept as true with all the ideas you’ve offered to your post. They are really convincing and will definitely work. Nonetheless, the posts are very brief for beginners. Could you please extend them a little from subsequent time? Thanks for the post.

Responder

Simply a smiling visitor here to share the love (:, btw great style and design .

Responder

I blog quite often and I truly appreciate your content. The article has really peaked my interest. I am going to take a note of your blog and keep checking for new details about once per week. I opted in for your RSS feed as well.

Responder

whoah this blog is excellent i love studying your articles. Keep up the good work! You already know, lots of individuals are hunting round for this information, you could help them greatly.

Responder

You made some respectable points there. I viewed on the internet for the issue and found most individuals will support with your internet site.

Responder

I’d like to thank you for the efforts you have put in penning this blog. I am hoping to see the same high-grade blog posts from you in the future as well. In truth, your creative writing abilities has inspired me to get my own blog now 😉

Responder

There are some interesting cut-off dates in this article however I don’t know if I see all of them heart to heart. There may be some validity however I will take hold opinion until I look into it further. Good article , thanks and we would like extra! Added to FeedBurner as effectively

Responder

buy prescription drugs online

Responder

It is appropriate time to make some plans for the future and it is time to be happy. I have read this post and if I could I desire to suggest you some interesting things or advice. Perhaps you could write next articles referring to this article. I desire to read even more things about it!

Responder

Aw, this was a very nice post. In concept I want to put in writing like this additionally – taking time and precise effort to make an excellent article… but what can I say… I procrastinate alot and on no account appear to get something done.

Responder

Great info. Lucky me I found your blog by chance (stumbleupon). I have bookmarked it for later!

Responder

Hiya, I’m really glad I have found this information. Nowadays bloggers publish just about gossips and web and this is actually irritating. A good site with interesting content, that is what I need. Thanks for keeping this web site, I’ll be visiting it. Do you do newsletters? Cant find it.

Responder

When I initially commented I clicked the -Alert me when brand-new comments are included- checkbox as well as now each time a comment is included I get four emails with the same remark. Is there any way you can eliminate me from that service? Many thanks!

Responder

Pretty nice post. I just stumbled upon your weblog and wished to say that I have truly enjoyed browsing your blog posts. In any case I will be subscribing to your feed and I hope you write again soon!

Responder

An impressive share! I have just forwarded this onto a colleague who was doing a little homework on this. And he in fact bought me lunch because I found it for him… lol. So allow me to reword this…. Thank YOU for the meal!! But yeah, thanx for spending time to discuss this issue here on your internet site.

Responder

Pretty nice post. I just stumbled upon your blog and wished to say that I have truly enjoyed surfing around your blog posts. After all Ill be subscribing to your feed and I hope you write again very soon!

Responder

I love looking through a post that can make men and women think. Also, many thanks for allowing for me to comment!

Responder

I am curious to find out what blog system you’re using? I’m experiencing some minor security problems with my latest site and I would like to find something more risk-free. Do you have any solutions?

Responder

Our Mushroomburger The signature Mushroomburger patty was created back in 1979. Still to everyone’s surprise, it is approximately made up of 50 mushrooms and 50 real beef.

Responder

Hi my friend! I wish to say that this article is amazing, nice written and include approximately all vital infos. I’d like to see more posts like this.

Responder

When I initially commented I clicked the -Notify me when brand-new remarks are added- checkbox and also now each time a comment is included I get four emails with the same remark. Exists any way you can remove me from that solution? Thanks!

Responder

Its superb as your other content : D, regards for posting . «The squeaking wheel doesn’t always get the grease. Sometimes it gets replaced.» by Vic Gold.

Responder

If you are viewing come up with alter in most of the living, starting point generally L . a . Weight reduction cutting down on calories platform are a wide stair as part of your attaining that most agenda. weight loss

Responder

This is the right web site for anybody who wants to understand this topic. You know so much its almost tough to argue with you (not that I personally will need to…HaHa). You certainly put a fresh spin on a topic that has been discussed for many years. Wonderful stuff, just excellent!

Responder

Definitely, what a magnificent blog and illuminating posts, I surely will bookmark your blog.All the Best!

Responder

book hotels, find hotels, discount hotels, hotel deals, compare hotels, search for hotels, best hotels, hotel deals, hotel packages, city packages

Responder

Hey there! This post could not be written any better! Reading this post reminds me of my previous room mate! He always kept talking about this. I will forward this page to him. Pretty sure he will have a good read. Thanks for sharing!

Responder

netticasinot, parhaat netticasinot, netticasino

Responder

Wonderful beat ! I would like to apprentice while you amend your site, how could i subscribe for a blog website? The account helped me a acceptable deal. I had been tiny bit acquainted of this your broadcast offered bright clear idea

Responder

certainly like your web site but you have to check the spelling on several of your posts. Many of them are rife with spelling problems and I find it very bothersome to tell the truth nevertheless I’ll surely come back again.

Responder

Definitely, what a splendid website and instructive posts, I will bookmark your blog.Best Regards!

Responder

Oh my goodness! Amazing article dude! Many thanks, However I am experiencing troubles with your RSS. I don’t understand why I cannot join it. Is there anyone else getting similar RSS issues? Anyone who knows the solution will you kindly respond? Thanks!!

Responder

Oh my benefits! an outstanding write-up man. Thanks Nonetheless I am experiencing issue with ur rss. Don?t recognize why Not able to sign up for it. Is there anyone obtaining identical rss problem? Any person who knows kindly respond. Thnkx

Responder

Wow, amazing blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your website is fantastic, let alone the content!

Responder

Site Rank Services offers affordable premium SEO packages & helps increase the visibility of your site in the search engines. We help you generate more profits

Responder

I intended to create you the little bit of note to finally thank you very much once again for those pleasant knowledge you have contributed at this time. It was so strangely generous with you to supply unreservedly precisely what a few individuals would have offered as an e book to help with making some dough for their own end, most notably considering that you could have tried it if you ever desired. These techniques also served to become easy way to comprehend some people have a similar passion the same as my own to find out way more related to this problem. I know there are some more pleasant opportunities in the future for many who browse through your blog.

Responder

Hello. excellent job. I did not imagine this. This is a remarkable story. Thanks!

Responder

This website is my inspiration , very wonderful pattern and perfect content .

Responder

I’ve recently started a website, the info you provide on this web site has helped me tremendously. Thanks for all of your time & work.

Responder

May I simply say what a comfort to find a person that genuinely understands what they are talking about online. You certainly realize how to bring an issue to light and make it important. More people have to check this out and understand this side of your story. I can’t believe you’re not more popular because you most certainly possess the gift.

Responder

Your house is valueble for me. Thanks!…

Responder

Shopify fitness store

Responder

I must point out my admiration for your generosity supporting women who should have guidance on this one study. Your personal dedication to passing the message all-around turned out to be especially effective and has frequently encouraged ladies like me to achieve their endeavors. Your own useful report denotes a great deal a person like me and even further to my colleagues. Thanks a ton; from each one of us.

Responder

When I originally commented I appear to have clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I recieve four emails with the exact same comment. There has to be a means you can remove me from that service? Appreciate it!

Responder

I would like to thank you for the efforts you have put in writing this web site. I’m hoping the same high-grade site post from you in the upcoming also. In fact your creative writing skills has inspired me to get my own web site now. Really the blogging is spreading its wings rapidly. Your write up is a good example of it.

Responder

Howdy! Quick question that’s entirely off topic. Do you know how to make your site mobile friendly? My weblog looks weird when browsing from my iphone4. I’m trying to find a template or plugin that might be able to resolve this issue. If you have any suggestions, please share. Appreciate it!

Responder