Saltar al contenido
PROGRAMAR EN VBA MACROS DE EXCEL

Cambia de minúscula a mayúscula y viceversa

Procedimiento para pasar de minúscula a mayúscula y viceversa:

1) Pasar todo a mayúscula: el siguiente es un procedimiento extremadamente sencillo, lo que hace es pasar toda el contenido de la celda activa a mayúscula.

Sub mayuscula()
ActiveCell = UCase(ActiveCell)
End Sub

2) Pasar todo a minúscula: el siguiente es un procedimiento extremadamente sencillo, lo que hace es pasar toda el contenido de la celda activa a minúscula.

Sub minuscula()
ActiveCell = LCase(ActiveCell)
End Sub

Al trabajar con cadenas de texto es necesario  poder extraer ciertos caracteres, a partir de un espacio,  de cierta posición, caracteres que se encuentran a la derecha o izquierda, invertir cadenas, etc. para ello existen funciones útiles para manipular cadenas de texto o  string, en el link tienes un ejemplo sobre como manipular cadenas de texto.

Si te fue de utilidad puedes INVITARME
UN CAFÉ
 y de esta manera ayudar a seguir
manteniendo la página.

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

If this post was
helpful INVITE ME A COFFEE and so help keep
up the page.

Entradas relacionadas

Deja un comentario

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

Comentarios (28)

I am the owner of JustCBD label (justcbdstore.com) and I’m presently seeking to develop my wholesale side of company. I really hope that someone at targetdomain give me some advice ! I thought that the most suitable way to do this would be to reach out to vape companies and cbd stores. I was hoping if anyone could suggest a dependable web site where I can get CBD Shops Business Sales Leads I am already considering creativebeartech.com, theeliquidboutique.co.uk and wowitloveithaveit.com. Unsure which one would be the most ideal solution and would appreciate any guidance on this. Or would it be simpler for me to scrape my own leads? Suggestions?

Responder

Проведем официальную процедуру и это процедура банкротство юридических лиц тема знакома каждому учредителю

Responder

Pretty! This was an incredibly wonderful article. Many thanks for supplying this info.

Responder

That is a really good tip particularly to those fresh to the blogosphere. Brief but very accurate information… Thank you for sharing this one. A must read article!

Responder

I blog quite often and I really appreciate your information. Your article has truly peaked my interest. I will take a note of your blog and keep checking for new information about once a week. I subscribed to your RSS feed too.

Responder

A motivating discussion is definitely worth comment. I do think that you should publish more on this topic, it might not be a taboo subject but generally folks don’t speak about such subjects. To the next! Kind regards!!

Responder

This blog was… how do I say it? Relevant!! Finally I’ve found something which helped me. Cheers!

Responder

I truly love your site.. Excellent colors & theme. Did you develop this amazing site yourself? Please reply back as I’m looking to create my own personal blog and would love to know where you got this from or just what the theme is named. Thanks!

Responder

I want to to thank you for this wonderful read!! I definitely enjoyed every little bit of it. I have you bookmarked to check out new things you post…

Responder

Pretty! This has been a really wonderful post. Many thanks for supplying this information.

Responder

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

Responder

I was able to find good info from your content.

Responder

I really like it when individuals get together and share opinions. Great blog, keep it up!

Responder

I’m impressed, I have to admit. Rarely do I encounter a blog that’s both equally educative and amusing, and without a doubt, you have hit the nail on the head. The problem is something that too few people are speaking intelligently about. I’m very happy I came across this during my search for something concerning this.

Responder

Good web site you have got here.. It’s hard to find high-quality writing like yours nowadays. I seriously appreciate individuals like you! Take care!!

Responder

I was very happy to uncover this website. I want to to thank you for ones time just for this fantastic read!! I definitely really liked every little bit of it and I have you saved as a favorite to see new things in your website.

Responder

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

Responder

I truly love your blog.. Very nice colors & theme. Did you create this website yourself? Please reply back as I’m planning to create my very own website and want to learn where you got this from or exactly what the theme is named. Cheers!

Responder

Very good information. Lucky me I recently found your blog by accident (stumbleupon). I have bookmarked it for later!

Responder

This is a very good tip especially to those fresh to the blogosphere. Brief but very precise info… Many thanks for sharing this one. A must read article!

Responder

I really like it whenever people get together and share opinions. Great website, keep it up!

Responder

Hi! I simply would like to offer you a huge thumbs up for the excellent info you have got right here on this post. I’ll be returning to your site for more soon.

Responder

This web site certainly has all of the information and facts I needed about this subject and didn’t know who to ask.

Responder

Pretty! This has been an extremely wonderful post. Thanks for providing these details.

Responder

I like it when individuals get together and share views. Great blog, keep it up!

Responder

You’re so cool! I don’t suppose I’ve read something like that before. So great to discover somebody with unique thoughts on this subject matter. Seriously.. thank you for starting this up. This site is something that’s needed on the web, someone with a little originality!

Responder

It’s difficult to find well-informed people on this subject, however, you seem like you know what you’re talking about! Thanks

Responder

I was very pleased to find this web site. I need to to thank you for ones time due to this wonderful read!! I definitely liked every bit of it and I have you saved as a favorite to look at new things in your website.

Responder